removing last 16 digits of the value of a cell

D

destrolennox

Hello,

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

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

Smith, John M. xxxxxx4023820886

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

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

Thanks for the help,

Brenda
 
V

VBA Noob

Looks like you could use Text to columns

Data > Text to Columns

Click delimter and use Other with the aposthophe sign ","

Otherwise you could try =right(A1,16)

VBA Noo
 
Top