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