| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
white space deletion
Greetings,
I have gone through the help section in Exel trying to understand how to delete white spaces in Column A. Column A is a list of employee numbers and after each number is a space. How do I delete that space in one big sweep since there are over 700 different numbers listed, all with a space after them? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
white space deletion
If you need to remove all the spaces you can do it using find & replace on
the edit menu. Put a space in the find box and nothing in the replace box and then click replace all. John "JOMARFL" wrote: Greetings, I have gone through the help section in Exel trying to understand how to delete white spaces in Column A. Column A is a list of employee numbers and after each number is a space. How do I delete that space in one big sweep since there are over 700 different numbers listed, all with a space after them? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
white space deletion
=TRIM(A1)
Copy all the way down as far as needed "JOMARFL" wrote: Greetings, I have gone through the help section in Exel trying to understand how to delete white spaces in Column A. Column A is a list of employee numbers and after each number is a space. How do I delete that space in one big sweep since there are over 700 different numbers listed, all with a space after them? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issues with white space when printing & with wrapping text | Excel Discussion (Misc queries) | |||
| How do I remove white space around a chart? | Charts and Charting in Excel | |||
| Excel - fill white space in cells | Excel Discussion (Misc queries) | |||
| White Space in a Cell | New Users to Excel | |||
| Excel save as htm with functionality too much white space | Excel Discussion (Misc queries) | |||
Linear Mode
