Hi
If for example cell A1 had your 3 letters in it and cell
B1 had your 2 numbers, then in order to put the two
combined into D1 you would need to type the following
formula into the cell D1
=A1&B1
Libby
-----Original Message-----
I am trying to make a database that makes e-mail addrsse
from 3 letters
in one colunm(hnd), two numbers from another colum(01
from 2001) ie:
the last two numbers and first letter of a first name and
the first
ltter of the last name from two other colunms
any help??
:(
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
.