Help
Join Now
Remember me
Forgot your
username
/
password
?
Safer Gambling
Exchange
Sportsbook
Virtual Sports
Betfair Community
Everything
Forums
Blogs
Search
launch community pop-up
Home
›
General Betting Forum
›
EXCEL QUESTION: Trim
Switch to Community Classic
App Directory
Forums
Forum - How To Join
Announcements
Service
New Products and Features
Forum Chat
Site Feedback
Sports
Football
Horse Racing
Ante Post Racing
Bloodstock & Breeding
US Racing
Cheltenham Festival
Grand National
Golf
Cricket
Tennis
Cycling
Darts
Rugby
Snooker
Greyhounds
Australian
American Football
Basketball
Boxing
Mixed Martial Arts
Irish Sports
Motor Sports
Poker
Games
Other
Specials
General Betting
Chit Chat
Politics
Tradefair & Financials
Your Competitions
Developers
Labs Chat
Help Forum
Guidelines
Terms & conditions
General Betting
Forum
General Betting Blogs
Welcome to Live View – Take the tour to learn more
Start Tour
‹ back to topics
There is currently 1 person viewing this thread.
EXCEL QUESTION: Trim
SHAPESHIFTER
Date Joined:
04 Apr 03
Blogger:
SHAPESHIFTER's blog
Add contact
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
Play
•
Switch to Standard View
EXCEL QUESTION: Trim
Show More
Report
SHAPESHIFTER
•
February 1, 2011 11:10 PM GMT
For reply:
A22 is:
No. 63 I WANT TO KEEP THIS
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))
Try ~=TRIM(MID(A22,8,LEN(A22)-7))
Report
Stow_judge
•
February 2, 2011 12:26 AM GMT
=RIGHT(A22,(LEN(A22)-8))
=RIGHT(A22,(LEN(A22)-8))
Report
Stow_judge
•
February 2, 2011 12:27 AM GMT
...
http://www.techonthenet.com/excel/formulas/index.php
...
...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.
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
...
lots more on my websitehttp://www.smashiton.com/Main/Computing.htm...
Post Your Reply
Text Format:
Table:
Smilies:
Remove
said
<CTRL+Enter> to submit
<Enter> to submit
Post Reply
↵
Please login to post a reply.
Wonder
Instance ID: 13539
launch community pop-up
www.betfair.com
Betfair