special formula

D

David

I am trying to create a ID number using the first 4 letters of a persons last name (Cell A1) with the last 4 digits of the persons Social Security number (Cell F1) and have it display in Cell E1 in Excell, does anyone know a formula that will do this?
 
N

Norman Harker

Hi David!

Try:
=LEFT(A1,4)&RIGHT(F1,4)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
Top