Remove Space

[RonH]

I have a column where all the entries have 1 space in
front of them. I have tried to fix through formating, but
it will not change. Is there a formula i can use that
will remove the space in front of each cell??

Ron

 

[Peo Sjoblom]

One way, use a help column, assume the text start in A1

=TRIM(A1)

if that does not help then it is not a space, then you can do

=RIGHT(A1,LEN(A1)-1)

 

[RonH]

Thank you for the help, the only problem with TRIM() is
that some of the names have middle initials for example "
John H" or " Sue Ann". I need to move the first character
one space to the left, but not remove the middle spaces,
is this possible??? Thanks for the help

 

[Peo Sjoblom]

It won't remove middle spaces unless there is more than one, trim removes
leading,
trailing and change multiple spaces into a single space