How to combine dat from 4 fields into one field

M

mdeanda

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?
 
P

Peo Sjoblom

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
 
Top