View Single Post
  #3   Report Post  
jiwolf
 
Posts: n/a
Default

enter into cell A5 "=A1&A2&A3"

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