Remove Space

  • Thread starter Thread starter RonH
  • Start date Start date
R

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
 
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)
 
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
 
It won't remove middle spaces unless there is more than one, trim removes
leading,
trailing and change multiple spaces into a single space
 
Back
Top