trimming cells

[Tejas Kokje]

I am trying to trim the "N0001271226 " which is in cell(1,2)which has
extra space at end (string that remains after discarding quotes)

I am using Sheet1.Cells(1,4).value = Trim(Sheet1.Cells(1,2).Value) to
copy trimmed string into Sheet1.Cells(1,4). Yet the new string is not
trimmed.

Any suggetions. I am a novice vba programmer and hence I might have
missed few important points.

Regards,
Tejas Kokje

 

[smalltalk_vb]

I tried the following in the intermidate window and it
worked.

If A1 contained "N0001271226 ", it worked.

?Trim(sheet2.Cells(1,1).value) & "*"
N0001271226*
N0001271226*
N0001271226 *
N0001271226

Mr. Tucker
California

 

[Frank Kabel]

Hi
try
Sheet1.Cells(1,4).value = replace(Sheet1.Cells(1,2).Value," ","")

You may also take a look at
http://www.mvps.org/dmcritchie/excel/join.htm#TRIMALL

 

[Tushar Mehta]

An occasional problem is that what looks like a space is not a space!
One culprit is CHAR(160), which, if I remember correctly, is a 'non
breaking space.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions