| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove trailing spaces from multiple columns in Excel
You want to do a match, but there are extra spaces in one set of data?
If that's what you're asking, you can use the TRIM function to remove extra spaces before trying the match. If not, you may have to be more precise is asking your question. On May 16, 2:29 pm, freetry wrote: I have a two spreadsheets with the same information and want to compare account ID, which is on both sheets and on a match, change the information in one field. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
