Posted to microsoft.public.excel.misc
|
|
removing last 16 digits of the value of a cell
Try:
=LEFT(A1,LEN(A1)-16)
-Simon
"destrolennox" wrote:
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
|