concatenate won't work

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)
 
J

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
 
R

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
 
G

Glenn

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)

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

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.
 
T

TracySLPS

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top