Prev: compile data base on hit
Next: Saving an Excel Spreadsheet outside of Excel Recent Documents
From: Ms-Exl-Learner on 1 Apr 2010 23:00
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
>
 | 
Pages: 1
Prev: compile data base on hit
Next: Saving an Excel Spreadsheet outside of Excel Recent Documents