formula to display only part of acct #

[Aladin Akyurek]

=RIGHT(A1,4)

Hello All
I am working on a project where we are mailing out letters to customers.

In an excel spreadsheet I have the customers account number and I am using a
mail merge in MS word to put all of the correct infomation in the
letter(cust name, address, type of acct , etc.) . THe one catch is that I do
not want to put the enitre account number, only the last 4 digits. Does
anyone know a formula that would make it so only the last 4 digits of the
account number would be displayed once i do the mail merege. I am thinking
that I am going to crate a new column in excel for this , but i dont want to
manually change several thousand acct #s.

so if i created a new column what type of formula could I use so that only

the last 4 digits are shown. THanks in advance!

 

[Guest]

Hello Al
I am working on a project where we are mailing out letters to customers. In an excel spreadsheet I have the customers account number and I am using a mail merge in MS word to put all of the correct infomation in the letter(cust name, address, type of acct , etc.) . THe one catch is that I do not want to put the enitre account number, only the last 4 digits. Does anyone know a formula that would make it so only the last 4 digits of the account number would be displayed once i do the mail merege. I am thinking that I am going to crate a new column in excel for this , but i dont want to manually change several thousand acct #s

so if i created a new column what type of formula could I use so that only the last 4 digits are shown. THanks in advance
-RIch

 

[Norman Harker]

Hi Rich!

Use:
=RIGHT(A1,4)

Returns as text. If you want to return as a number use:

=--RIGHT(A1,4)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hello All
I am working on a project where we are mailing out letters to

customers. In an excel spreadsheet I have the customers account number
and I am using a mail merge in MS word to put all of the correct
infomation in the letter(cust name, address, type of acct , etc.) .
THe one catch is that I do not want to put the enitre account number,
only the last 4 digits. Does anyone know a formula that would make it
so only the last 4 digits of the account number would be displayed
once i do the mail merege. I am thinking that I am going to crate a
new column in excel for this , but i dont want to manually change
several thousand acct #s.

so if i created a new column what type of formula could I use so

that only the last 4 digits are shown. THanks in advance!

 

[Lance]

try using a RIGHT formula in a seperate column....=RIGHT(A3,4)

-----Original Message-----
Hello All
I am working on a project where we are mailing out letters

to customers. In an excel spreadsheet I have the customers
account number and I am using a mail merge in MS word to
put all of the correct infomation in the letter(cust name,
address, type of acct , etc.) . THe one catch is that I do
not want to put the enitre account number, only the last 4
digits. Does anyone know a formula that would make it so
only the last 4 digits of the account number would be
displayed once i do the mail merege. I am thinking that I
am going to crate a new column in excel for this , but i
dont want to manually change several thousand acct #s.

so if i created a new column what type of formula could I

use so that only the last 4 digits are shown. THanks in
advance!