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

--
Regards,

Peo Sjoblom


"mdeanda" wrote in message
...
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?