Use & function

[neeraj2050]

Greetings!!
I want to get data from all the cells i.e A1 to Z1 into my sheet to A2 cell.
For this I can use & function. But I will have to do it by selecting each cell one by one. Is there any shortcut to that?

Regards
Neeraj Kumar Agarwal

 

[Abhay Mathur]

i don't know the solution with use of formula , but what i do is copy all cells (A1 to Z1) , paste it in notepad , again copy from notepad and paste in A2 cell (in F2 mode i.e in formula bar)..

 

[Atlas Johnson]

If you are using the new version of Excel 2016, you can use CONCAT or TEXTJOIN functions.