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