I'm new to excel and need help

P

peplogic

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??
:confused: :confused: :(
 
L

Libby

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert word into numbers and back 4
format cells 1
Format colum for number and next colum age 5
format colum for identity number and next colum age 1
Permutations Help on Excel 0
I really need help 1
Capitalisation of First Letter in Name 4
Anyone speak Japanese excel? 1

Top