If your data is starting from 1st row use the below forumla:-
Paste this formula in C1 cell
=TRIM(B1)
Copy and paste the C1 cell and paste it to the remaining cells of C Column.

If your data is starting from 2nd row use the below forumla:-
Paste this formula in C2 cell
=TRIM(B2)
Copy and paste the C2 cell and paste it to the remaining cells of C Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Jim D." wrote:

I've managed to stumble upon a solution. By using Text to Columns.

This works nicely but now my 2nd column entry's have an empty space before
each word.

Anybody know How I can get rid of the empty space before the word?


Thanks,

Jim