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