Forums

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