View Full Version : CONCATENATE usage

2011-08-22, 09:31 PM

I have two question

1) I have a huge column... and I want contents of each cell to be taken and put in one single cell .... how can I employ the "concatenate" function to select huge range ?

2) How do I add some certain character to the end of each cell in range?
For example is I have: text1, text2, text3 and I want to get text1A, text2A, text 3A and etc...

Thanks :)

Roger Govier
2011-08-22, 10:45 PM

Post an example with a complete description

Bob Phillips
2011-08-23, 12:31 AM
Easiest way is to add a formula in an adjacent cell to take cell & concatenate, autofill down, copy /paste values on the new cells and delete the original column.