Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TRIM Q
I am trying to use the TRIM function but it is not removing the space
I expect A1 references to another field, and returns the value CT 1. I am trying to remove the <space between T and 1. When I use the TRIM function within cell A1 the value remains as CT 1. I have even checked this with the LEN function and it returns 4. The cell which A1 is referenced has a simple typed in value of CT 1, the cell is formatted as General What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TRIM Q
Nothing wrong, as that's the way TRIM functions.
From Excel's help, TRIM: Removes all spaces from text except for single spaces between words The space between "CT" and "1" is a single space, hence TRIM will not remove it You could try SUBSTITUTE Eg in B1: =SUBSTITUTE(A1," ","") -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:362 Subscribers:64 xdemechanik --- "Seanie" wrote in message ... I am trying to use the TRIM function but it is not removing the space I expect A1 references to another field, and returns the value CT 1. I am trying to remove the <space between T and 1. When I use the TRIM function within cell A1 the value remains as CT 1. I have even checked this with the LEN function and it returns 4. The cell which A1 is referenced has a simple typed in value of CT 1, the cell is formatted as General What am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TRIM Q
Hello
TRIM will always leave one space between words. Try this with your text in B1: =SUBSTITUTE(B1," ","") Regards, Per "Seanie" skrev i meddelelsen ... I am trying to use the TRIM function but it is not removing the space I expect A1 references to another field, and returns the value CT 1. I am trying to remove the <space between T and 1. When I use the TRIM function within cell A1 the value remains as CT 1. I have even checked this with the LEN function and it returns 4. The cell which A1 is referenced has a simple typed in value of CT 1, the cell is formatted as General What am I doing wrong? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TRIM Q
Aaah, thanks Guys
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=TRIM | Excel Discussion (Misc queries) | |||
trim | Excel Discussion (Misc queries) | |||
TRIM | New Users to Excel | |||
Trim | Excel Discussion (Misc queries) | |||
trim | New Users to Excel |