remove spaces in front of text
 

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

remove spaces in front of text
 

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

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