Hi All

About 3/4 Hr ago I sent an Email using your solution a shortened example below

4100,WM10677
Below is what I received back
4100,WM10677 ,262,1398

Is it possible that on cut and paste in to Excel Column E that the two
WM10677 Code Numbers would automatically match on the same row.in Columns B &
E.

I know what I want to happen but on reading the above appears crazy!!!

Cheers

Mully



"mully" wrote:

Thank You Gentlemen

Problem Solved --- thank goodness for some very intelligent help people.

Cheers

Mully

"Bob Phillips" wrote:

Try

=TRIM(A2)&","&TRIM(B2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mully" wrote in message
...
Hi All

On a worksheet
Cell A2 = 4100,
Cell B2 = WM0001
CellD2 when using Text to Columns = 4100, WM0001
how do I get rid of the space so that Cell D2 = 4100,WM0001
I Email over 400 rows of similar information and Cell D2 must not have any
spaces.
I can do it manually but with over 400 rows its a pain - could a macro or
perhaps a VBA function do it automatically.

Any help appreciated

Cheers

Mully