Splitting data from cells into multiple lines

  • Thread starter Igneshwara reddy
  • Start date
I

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
 
I

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
 
A

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
 
I

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
 
G

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.
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding duplicates 2
Lookup Wizard 4
Multiples conditions in an array 3
collapse rows into one 2
Count unique with multiple criteria 3
array search 8
Data Matching 1
lookup with IF criteria 2

Top