Menu

Removing trailing spaces from cells ?

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Don Guillett

Posts: n/a

Default

Removing trailing spaces from cells ?

Have a look at TRIM

--
Don Guillett
SalesAid Software

"Ian" wrote in message
...
Is there a way of removing all the trailing spaces from cells?

i.e Henry James<space<space<space becomes Henry James

and

John<space<space<space<space<space etc becomes John.

Thanks in advance.

Reply With Quote

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
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
Removing ' character from cells	Don	Excel Discussion (Misc queries)	5	December 21st 04 05:41 PM
Sumproduct ... Empty Cells vs Spaces?	Ken	Excel Discussion (Misc queries)	9	December 17th 04 08:03 PM
Cells and and spaces after a string of text	H	Excel Worksheet Functions	2	November 19th 04 08:26 PM
Removing Spaces in a Cell	carl	Excel Worksheet Functions	2	October 28th 04 11:34 PM

All times are GMT +1. The time now is 10:04 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement