Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : Why =TRIM() formula not working ?
Hi,
Merry Christmas and Happy New Year. I import a report in Excel format from another business system, but there are always 6 empty spaces behind a column of reference say HG2145______. I try to use =TRM() to eliminate the trailing spaces but always fail. I get back the same thing. I could only do this by using =LEFT(A2,6) May I know why and is there any other ways of getting what I want ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Why =Trim () formula not working ? | Excel Discussion (Misc queries) | |||
Excel 2002: Vlookup formula not working | Excel Discussion (Misc queries) | |||
Excel trim not working | Excel Discussion (Misc queries) | |||
Excel 2002 not working | Setting up and Configuration of Excel | |||
I can't seem to use RTRIM or LTRIM in Excel 2002. I want to trim. | New Users to Excel |