Dave

Posts: n/a

Trim help please

How can I trim the last space from text but leave the other spaces intact
ie:- Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)

Sir Edward Landseer (FR) Sir Edward Landseer (FR)

I've tried =SUBSTITUTE(A1," ","") but this trims all the spaces out.
Any help will be welcomed.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trim and Keep the Trimmed Data	sally t	Excel Worksheet Functions	2	July 26th 05 02:29 PM
Excel TRIM() can't handle in pasted HTML	dyt	Excel Discussion (Misc queries)	2	March 31st 05 08:11 PM
Trim function doesn't clean out ASCII Code 160 (Space)	Ronald Dodge	Excel Worksheet Functions	6	January 27th 05 03:48 AM
Trim function	aehan	Excel Worksheet Functions	3	January 25th 05 12:31 PM
How to use TRIM function	Sky Warren	Excel Worksheet Functions	3	January 8th 05 05:06 PM

All times are GMT +1. The time now is 05:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us