Hello,

I have a quick question that I think can be easily answered, I am just
struggling to get it to work correctly.

I have a list of names and account numbers. The cells like like the
below example:

Smith, John M. xxxxxx4023820886

The "X"s were not put in by me, they actually exist like that in the
spreadsheet.

I would like to remove the 16 digit account number. Each name
obviously contains a different number of characters which is making
this difficult for me.

Thanks for the help,

Brendan


--
destrolennox
------------------------------------------------------------------------
destrolennox's Profile: http://www.excelforum.com/member.php...o&userid=36503
View this thread: http://www.excelforum.com/showthread...hreadid=562652