PC Review


Reply
Thread Tools Rate Thread

How can I remove a space from my cells?

 
 
Newbie
Guest
Posts: n/a
 
      21st Jul 2005
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.


 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      21st Jul 2005
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.
>
>



 
Reply With Quote
 
Newbie
Guest
Posts: n/a
 
      22nd Jul 2005
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.
>>
>>

>
>



 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      22nd Jul 2005
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.
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:48 AM.