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
There is currently 1 person viewing this thread.
01 Feb 11
23:09
Joined:
Date Joined:
04 Apr 03
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
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
sort by:
Show
per page
Replies: 6
|
By:
For reply:
A22 is: No. 63 I WANT TO KEEP THIS |
|
By:
Try ~
=TRIM(MID(A22,8,LEN(A22)-7)) |
|
By:
=RIGHT(A22,(LEN(A22)-8))
|
|
By:
...
http://www.techonthenet.com/excel/formulas/index.php ... |
|
By:
both work...thank you.....
Stow_judge, cheers for that link. |
|
By:
lots more on my website
http://www.smashiton.com/Main/Computing.htm ... |