Take part data from two fields and auto fill into 3rd field

K

Kevin K

needing to know how to take pieces of data from other fields and auto fill
into a 3rd field. For example, field one is First Name, Field Two is Last
Name, Field three is first two digits of first name followed by first three
digits of last name. How can I automatically create a formula to have excel
create this for me?
 

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

Auto-fill 1
Pivot Table Field based on two data area fields 3
How to adjust physical lengths of fields 5
Duplicate entries 5
Create a web site link from a part link and a data field in access 2003 1
Look up field and auto fill the rest 4
Vlookup a text string 6
Comparing two lists using two columns from each spreadsheet 1

Top