remove spaces in front of text

D

dolphin

I need to remove the 4 and the 9 spaces after so my cell F55 will only read
Educate patient/care giver regarding behavior modification program purpose,
goals, and use in home/community environment instead of 4 Educate
patient/care giver regarding behavior modification program purpose, goals,
and use in home/community environment.

Any suggestions
 
D

Dave Peterson

You could use a helper cell:
=trim(a1)
This will remove leading, trailing and change multiple embedded spaces to a
single space.

Then you could drag it down the column
Edit|Copy
Edit|paste special|values
and delete the original column.
 
Top