removing blank spaces

[jv]

Good day to all,

We received 5 different report from our various dept. and
we combined all these 5 files into 1. The problem here is
that some of the report had 1 or 2 spaces before they type
the material description and some are not.

Is there a way to remove all these blank spaces, so that
we could manage to sort it correctly and make it all in
one straight order.

For your kind assistance.

Thanks and regards.

jv

 

[Norman Harker]

Hi jv!

You could insert a helper column and use:

=TRIM(A1)

Removes spaces other than a single one between words.

After using TRIM you can

Copy
Edit > Paste Special > Values > OK
Remove previous data.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[jv]

Hi Norman,

Thank you so much for the additional knowledge you've
impart to me, it lessens our workload.

Regards,

jv

 

[Norman Harker]

Hi jv!

Your welcome! It would be a real bind to do it manually.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.