| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Taking out an Extra space before some entries in a column
I have an column called "email" with several records having an extra space
at the being of their entry. Is there an automated way to get rid of that extra space without having to touch each record? -- --coastal |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Taking out an Extra space before some entries in a column
In a helper column =TRIM(A1) and fill down.
Copy Edit Paste Special Values OK to get rid of the formulas and copy back to the original column.. HTH Regards Howard "coastal" wrote in message ... I have an column called "email" with several records having an extra space at the being of their entry. Is there an automated way to get rid of that extra space without having to touch each record? -- --coastal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete extra space | Excel Worksheet Functions | |||
| How do I delete an extra space in every cell in a column? | Excel Discussion (Misc queries) | |||
| Extra Line Space | Excel Discussion (Misc queries) | |||
| Extra Line Space | Excel Discussion (Misc queries) | |||
| Extra Line Space | Excel Discussion (Misc queries) | |||
Linear Mode
