How can I remove a space from my cells?

's Computer Specifications

I have a few thousand names in a worksheet and some of them have a space in
the beginning of the name that I want to get rid of.

Example: (notice the space before the "J")
John Doe

How can I get rid of all these?

thanks.

's Computer Specifications

Hi Newbie

See
http://www.rondebruin.nl/clean.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Newbie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>I have a few thousand names in a worksheet and some of them have a space in the beginning of the name that I want to get rid of.
>
> Example: (notice the space before the "J")
> John Doe
>
> How can I get rid of all these?
>
> thanks.
>
>

's Computer Specifications

Wow, I have no idea what I just looked at on the site...

All I want to do is remove one space from the left in column A. Can someone
post the forumula? Thanks.

"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Newbie
>
> See
> http://www.rondebruin.nl/clean.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Newbie" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have a few thousand names in a worksheet and some of them have a space
>>in the beginning of the name that I want to get rid of.
>>
>> Example: (notice the space before the "J")
>> John Doe
>>
>> How can I get rid of all these?
>>
>> thanks.
>>
>>
>
>

's Computer Specifications

See the Excel help for Trim

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Newbie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Wow, I have no idea what I just looked at on the site...
>
> All I want to do is remove one space from the left in column A. Can someone post the forumula? Thanks.
>
>
> "Ron de Bruin" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>> Hi Newbie
>>
>> See
>> http://www.rondebruin.nl/clean.htm
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Newbie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>>I have a few thousand names in a worksheet and some of them have a space in the beginning of the name that I want to get rid of.
>>>
>>> Example: (notice the space before the "J")
>>> John Doe
>>>
>>> How can I get rid of all these?
>>>
>>> thanks.
>>>
>>>
>>
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove Space in Cells	Rebecca	Microsoft Excel New Users	9	8th Apr 2010 02:03 AM
Remove blank space in front of text in multiple cells at once	SMS	Microsoft Excel Misc	2	13th Jan 2009 08:04 AM
Re: Remove Space in Cells	elietebonallack@gmail.com	Microsoft Excel New Users	0	31st Mar 2008 05:36 PM
How to Remove a Partition (remove D Drive so space moves to C Driv	=?Utf-8?B?Q2hhbnRlbA==?=	Windows XP General	6	10th Apr 2006 05:43 PM
How do I remove a hidden space in Excel cells	=?Utf-8?B?RUogQg==?=	Microsoft Excel Misc	4	18th Nov 2005 07:25 PM