Merging Rows Into Single Cell In Excel (Calling Excel Gurus)

[vpraveen3843]

How to merge 15,000 row values into single cell. Evarikanna thelusa ela cheyalo. Its very urgent!

[pinky123]

aa cells anni okkate column lo unnaya?

[vpraveen3843]

yes anni okate column lo unnayi. motham 15,000 rows in one column..

[pinky123]

lets say nee data anta column A lo undi starting from A1..

B2 lo "=A1&" "&A2"
B3 lo "=B2&" "&A3"

* dont type double-quotes

taruvata B3 cell ni copy chesi.. B4 to B1500 motham highlight chesi paste cheyyi.. the above formula will place a "space" between the contents of each cell.

[vpraveen3843]

All 15000 row values oka cell loki ravali.., ila ayithe vasthaya?

[pinky123]

motham data only column A lo unte ee method tho vastundi

[Tatichettu_Tingarodu]

=concatenate() function vaduuuuuuuuuuuuuu

[vpraveen3843]

yes it worked brother, thanks..

[nrikittu]

ok

[Chicha1]

[img]http://www.andhrafriends.com/uploads/profile/photo-thumb-30724.jpg?_r=1343339226[/img]