Removing Leading Spaces

jlbecker67 · Mar 28th, 2002, 07:49 PM

I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

Mark W. · Mar 28th, 2002, 07:52 PM

Select 'em and choose the Data | Text to Columns... menu command.

Bob Umlas · Mar 28th, 2002, 08:06 PM

Edit/Replace; replace " " (without quotes) with "" (without quotes)
Bob Umlas
Excel MVP

Quote:

On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

Mark W. · Mar 28th, 2002, 08:10 PM

Quote:

On 2002-03-28 15:06, Bob Umlas wrote:
Edit/Replace; replace " " (without quotes) with "" (without quotes)
Bob Umlas
Excel MVP

Quote:

On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

...But be careful... because this will change " junk mail" into "junkmail".

[ This Message was edited by: Mark W. on 2002-03-28 15:11 ]

[ This Message was edited by: Mark W. on 2002-03-28 15:12 ]

Dave Hawley · Mar 28th, 2002, 10:34 PM

Hi

Text to Columns is probably the best solution. But the the TRIM function is good for this also, eg

=TRIM(A1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 07:49 PM	#1
jlbecker67 Join Date: Mar 2002 Posts: 8	I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells? Thanks, Jerry

Mar 28th, 2002, 07:52 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,653	Select 'em and choose the Data \| Text to Columns... menu command.

Mar 28th, 2002, 10:34 PM	#5
Dave Hawley Banned Join Date: Mar 2002 Posts: 1,582	Hi Text to Columns is probably the best solution. But the the TRIM function is good for this also, eg =TRIM(A1)