| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
| blank spaces in front of a number prevents formatting cell | Excel Discussion (Misc queries) | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Linear Mode
