Posted to microsoft.public.excel.misc

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

Removing Leading Space in Cell

=TRIM(A1)
--
Gary''s Student - gsnu200907

"Beverly-Texas" wrote:

That pretty much says it... I need to remove a blank space at the beginning
of content in a cell. Thanks in advance!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Removing leading and trailing space...	Jeffery B Paarsa	Excel Discussion (Misc queries)	2	October 8th 09 11:43 PM
removing a single space in a cell	birdsting	Excel Discussion (Misc queries)	4	May 10th 09 05:02 AM
removing space and tabs in a cell	mr_nice!	Excel Discussion (Misc queries)	5	November 28th 05 01:27 PM
removing a space between words in a cell	JenBasch	Excel Worksheet Functions	3	September 20th 05 12:39 AM
Removing a space within a cell	JERRY8	Excel Worksheet Functions	3	December 2nd 04 03:22 AM

All times are GMT +1. The time now is 12:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us