I imported text and need to Ltrim all the cells in a given row. How do
I do this?

Hi there,

You could use a simple loop for this. Here is an example ...

Sub DeleteAllLeadingSpacesPlease()
Dim c as Range
For each c in Range("A1:Z1")
c.Value = Ltrim(c.Value)
Next c
End Sub

Change the range to suit.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"lookin" wrote in message
oups.com...
I imported text and need to Ltrim all the cells in a given row. How do
I do this?

Thank you! It worked perfect!