Splitting data from cells into multiple lines

[Igneshwara reddy]

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

 

[Don Guillett]

Show before/after example

 

[Igneshwara reddy]

Now in the spreadsheet it looks like

Before After
A1 cell 123 B1 cell 123
456 B2 cell 123
789 B3 cell 123

Like this it should split in the next column.

Regards,
Igneshwara Reddy

 

[Ashish Mathur]

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]

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

 

[Glenn]

It does work. Make sure you are using the keys on the keypad and not at the top
of the keyboard. Select "Other", then hold down the Alt key. Type 010 on the
keypad, then let go of the Alt key.

 

[Gord Dibben]

CTRL + j does the same thing thing as Alt + 0010 on the NumPad


Gord Dibben MS Excel MVP