How do you Concactenate Fields in Excel???

  • Thread starter Thread starter Guest
  • Start date Start date
Try this eg.
A1 = Red
B1 = Apple

Type the following in C1 =A1&B1

you get RedApple

if you want a Space in between the two words type this in C1 =A1&" "&B1
 
Back
Top