CONCATENATE usage

[Neitrino]

Hello,

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]

Hi

Post an example with a complete description

[Bob Phillips]

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.