Concatenate Help

[Peter1973]

I need to merge the data from a range of cells A1:A1000 i was hoping to use concatenate but cant seem to get this to work over multiple cells without having to select each one individually, is there a way to just select the range? Any help appreciated.

 

[Joe4]

Since you are using 365, you can use the new TEXTJOIN function.
See: TEXTJOIN function - Microsoft Support

Note if you do not have a delimiter, you can also simply use the CONCAT function, i.e.

=CONCAT(A1:A1000)

 

[Peter1973]

That is returning N/A. Sample of the list of data below :

 

[Peter1973]

thanks for the help ive fixed it was an error in my data

 

[Joe4]

thanks for the help ive fixed it was an error in my data

Makes sense.

You are welcome.
Glad I was able to help!