Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
80 Posts
Discussion Starter · #1 ·
I have a pricelist
it has about 1000 items on it
I need to put the information from 3 colums into 1

it won't allow me to copy and paste it. is there another way??

please help!!

thank you

Brion
 

·
Registered
Joined
·
4,193 Posts
You can copy and paste all three columns into one if you double click on the cell and copy it while editing the cell. Try the concatenation that I showed you in your other thread.
=concatenate(cell1,cell2,cell3)
 

·
Registered
Joined
·
7,837 Posts
Or you could use the Concatenate formula in a 4th column and bring the data together in that column - however, be sure to copy and paste special-values afterward, or, if you were to delete the original data, your formula would reference non-existent cells and all would be lost.
Oh, Jim types faster than me...
BTW, the ASAP utilitiy is worth having - I constantly find new uses for it.
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top