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

 

[Neitrino]

The VBA help file ??? where do I find it ?

 

[Neitrino]

The VBA help file ??? where do I find it ???

 

[Scott Huish]

When you are in the VB Editor. Hit the F1 key.