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 ... |