I used the formula and it worked just fine........thank you

"Dave Peterson" wrote:

If there are no internal spaces in the data in that list, then maybe you can
just:

select that range
edit|replace
what: (spacebar)
with: (leave blank)
replace all

If there are internal spaces in the data in that list, you could:

Insert a new column (to its right?)
and use a formula like:
=trim(a1)
to remove all leading and all trailing space characters. It'll also convert
multiple internal space characters to a single space.

Then you could drag this formula down the column.
Select the column
Edit|copy
and then select the original column
Edit|paste special|values

and delete that helper column that holds the formula.

Lacey1941 wrote:

I have a rather long list of names and some of them have a space at the
beginning while others don't.

Is there a way to move whole groups of names over one space or will I have
to move them manually one name at a time?

--

Dave Peterson