remove spaces in front of text
Thank you Dave that help me a lot
"Dave Peterson" wrote:
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.
dolphin wrote:
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
--
Dave Peterson
|