concatenate won't work

[TracySLPS]

I used a .txt file to import into excel. i have saved it as a .xlsx file and
now i need to concatenate columns p-t. all columns are text columns, i used
the below formula placing a comma after each value and it won't work. i don't
know what to do, help!

=CONCATENATE(P2,",",Q2,",",R2,",",S2,",",T2)

 

[Jacob Skaria]

Your formula should work..Please check the references

With the same references use & sign to get the same result

=P2&","&Q2&","&R2&","&S2&","&T2

 

[Rick Rothstein]

Describe "won't work"... I tried your formula and it worked fine for me.
Just so know, you don't need to use the CONCATENATE function to join text
together... you can use the ampersand to do that...

=P2&","&Q2&","&R2&","&S2&","&T2

 

[Glenn]

I used a .txt file to import into excel. i have saved it as a .xlsx file and
now i need to concatenate columns p-t. all columns are text columns, i used
the below formula placing a comma after each value and it won't work. i don't
know what to do, help!

=CONCATENATE(P2,",",Q2,",",R2,",",S2,",",T2)

What you need to do is explain "won't work", because the formula as written
above works just fine.

 

[TracySLPS]

Won't work means after I plug in the formula, absolutely nothing happens. I
figured it out. I copied the file into a new excel file and pasted special
with only values, it worked.

 

[TracySLPS]

I copied the file to a new excel sheet, using paste special w/only values,
then the formula worked, thanks.

 

[TracySLPS]

there was something behind the excel file that caused it not to work. I
copied the values only over to a new page and it worked. thanks.