TRIM Q

S

Seanie

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?
 
M

Max

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
 
P

Per Jessen

Hello

TRIM will always leave one space between words.
Try this with your text in B1:

=SUBSTITUTE(B1," ","")

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top