Concatenation error

Hi guys,

In the attached spreadsheet I keep getting a concatenation error, I basically want to do =concatenate(A2:G2) in cell I2 and copy it down. Im obv getting the concat error due to the data, any way around this?

Thanks,
Dean
concat-error.xls
deanlee17Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Either you do

Concatenate(A2,B2,C2,D2,E2,....

Or you go for a UDF in VBA
0
 
Brian PierceConnect With a Mentor PhotographerCommented:
concatenate must use single cell references - not ranges

A2&B2&C2&D2&E2&F2&G2  works
0
 
deanlee17Author Commented:
Thanks guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.