Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
SHAPESHIFTER
01 Feb 11 23:09
Joined:
Date Joined: 04 Apr 03
| Topic/replies: 3,204 | Blogger: SHAPESHIFTER's blog
Managed to kill a formula on an old spreadsheet and can't remember wording for TRIM() or is it another command

I want the following:
No. 63   I WANT TO KEEP THIS

to be in another cell like this:

I WANT TO KEEP THIS

NOTE: there are two spaces between 63 and I WANT

Cheers
Pause • Switch to Standard View EXCEL QUESTION: Trim
Show More
Loading...
Report SHAPESHIFTER • February 1, 2011 11:10 PM GMT
For reply:

A22 is:

No. 63   I WANT TO KEEP THIS
Report Compound Magic • February 1, 2011 11:32 PM GMT
Try ~

=TRIM(MID(A22,8,LEN(A22)-7))
Report Stow_judge • February 2, 2011 12:26 AM GMT
=RIGHT(A22,(LEN(A22)-8))
Report Stow_judge • February 2, 2011 12:27 AM GMT
...
http://www.techonthenet.com/excel/formulas/index.php
...
Report SHAPESHIFTER • February 2, 2011 9:30 AM GMT
both work...thank you.....

Stow_judge, cheers for that link.
Report Stow_judge • February 2, 2011 11:25 AM GMT
lots more on my website
http://www.smashiton.com/Main/Computing.htm
...
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com