Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an Excel spreadsheet of names, addresses, etc. that I need to use in a
mail merge to create labels. Several of the columns contain data with trailing spaces. I know how to use the TRIM command to remove trailing spaces one cell at a time, but is there a way to remove trailing spaces from multiple cells at once? There are 4 contiguous columns of 133 rows containing text with trailing spaces, and I don't relish removing those spaces one cell at a time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remove trailing spaces | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
How to have multiple columns in excel that will expand and colaps. | Excel Discussion (Misc queries) |