| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
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 "Don Guillett" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
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. Igneshwara reddy wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting data from cells into multiple lines
CTRL + j does the same thing thing as Alt + 0010 on the NumPad
Gord Dibben MS Excel MVP On Wed, 06 May 2009 09:52:04 -0500, Glenn wrote: 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. Igneshwara reddy wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting one cell into multiple cells | Excel Discussion (Misc queries) | |||
| Splitting data in multiple cells | Excel Discussion (Misc queries) | |||
| Splitting data into multiple fields. | Excel Worksheet Functions | |||
| Splitting data in cells | Excel Discussion (Misc queries) | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
![Igneshwara reddy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
