Hi,
The solution suggested is not working out for me. Not able to type the
numeric number in other field by holding the ALT key. It is allowing only one
numeric number.
Regards,
Igneshwara Reddy
"Ashish Mathur" wrote:
Hi,
Looks like the data has been entered in one cell by using Alt+Enter. Select
cell A1 and go to Data Text to columns Delimited OK Other. In the
other box, hold down the Alt key and press 010 on the numeric keypad. Now
click on OK and then finish. the data will be segregated into columns
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"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