remove spaces in front of text

  • Thread starter Thread starter dolphin
  • Start date Start date
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
 
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.
 
Thank you Dave that help me a lot

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing all spaces 4
Space in text 2
Remove blank space in front of text in multiple cells at once 2
Searching the formula (not the value) for a text string 1
Removing number spacing in cells 4
not sure if this will affect and mvp participation, but take a look 3
How to remove a space 5
Text cells, crosstabs? Drilling down? 1

Back
Top