Show before/after example
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Igneshwara reddy" wrote in
message ...
Hi,

I have the data in cells as

A1 cell: 123
456
789

A2 cell: abc
def
ghi
jkl
mno
pqr

This is how I have the data in cells and I need to move into different
lines.( each line into each cell)

Let me know how to go about this at the earliest.

Regards,
Igneshwara Reddy