concatenate won't work

  • Thread starter Thread starter TracySLPS
  • Start date Start date
T

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)
 
Your formula should work..Please check the references

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

=P2&","&Q2&","&R2&","&S2&","&T2
 
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
 
TracySLPS said:
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)
Click to expand...

What you need to do is explain "won't work", because the formula as written
above works just fine.
 
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.
 
I copied the file to a new excel sheet, using paste special w/only values,
then the formula worked, thanks.
 
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.
 
Back
Top