On Tue, 21 Aug 2007 05:35:11 -0700, gmunro wrote:

Hi,

I pull a report from a source I don't control.
The report has a list starting in cell B27 and is of variable length.

The problem I have is the programmers who I cannot influence, change
the number of spaces at the beginning of the list, and I use this
report for a vlookup, so exact match is required

They went from 15 spaces before teh data to none to 14.

How can I count the number of spaces and replace with "" in a specific
range?

Any help is appreciated

Glen

In Excel you can use the TRIM function to remove both leading and trailing
spaces as well as extra (more than one sequential) spaces within the text.

In VBA you can use the LTrim function to remove only leading spaces.


--ron