how to delete space

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Hi,

Please help! Thanks

Example.

Cloumn 1

jean anne
marie anna
michael andrew

I'd like to see the data like this it has no space before

jean anne
marie anna
michael andrew
 
Hi

use the Ltrim function like this:
'--------------------------------
Cells(x, y) = LTrim(Cells(x, y))
'--------------------------------

LTrim deletes any spaces before the text and RTrim removes
any spaces after the text.

Hope this helps

Tanner
 
Hi singkit

FYI, Ltrim and Rtrim are VBA functions. These would be used in a Macro

Regards
Mark Graesse
(e-mail address removed)
Boston M


----- Tanner wrote: ----

H

use the Ltrim function like this
'-------------------------------
Cells(x, y) = LTrim(Cells(x, y)
'-------------------------------

LTrim deletes any spaces before the text and RTrim removes
any spaces after the text

Hope this help

Tanne
 
Back
Top