How to combine dat from 4 fields into one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the follwing data in three fields

A1 A2 A3 A4
' Name '! Number

Desired Result
A1 A2 A3 A4 A5
' Name '! Number 'NAME'!NUMBER

Is their a function for this?
 
If you are looking to combine a string to return a cell address you need to
wrap it in INDIRECT

=A1&A2&A3&A4

use the ampersand to concatenate strings
 
You must log in or register to reply here.

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

Return Unique Entries Only 5
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Using two Vlookup in one Cell 1
Help Creating Excel Formula 4
Addition errors with Decimal Places 5
About Data Validation 2
How do I add sequential numbers to existing data in excel? 3
generate automatically sum 6

Back
Top