Thread: Splitting data from cells into multiple lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline
external usenet poster
  
Posts: 68
Default Splitting data from cells into multiple lines
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
Reply With QuoteReply With Quote