| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Great! Thanks that got it
"Harlan Grove" wrote: Anne Troy wrote... Have you selected the cells, then hit Format-Cells, Alignment tab. Make sure there's no indent, and that they're aligned left? .... Alignment might be a problem, but assuming the OP does know s/he's talking about, it's more likely the 'spaces' are HTML nonbreaking spaces (decimal character code 160) rather than ASCII spaces 9decimal character code 32). The OP may have better luck changing the formula to =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel files in separate program windows | Excel Discussion (Misc queries) | |||
| Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
| excel stopped working | Excel Discussion (Misc queries) | |||
| Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions | |||
Threaded Mode
