Split Data in Columns

Hi,
How do i get my data be splited into new columns

like we usually do through Text to Column method of single cell data


i dont know how to split here the data when data is entered in new lines in a single cell using Alt + Enter.

pls refer attachement. i want this to be splitted into new columns


Each new line data should be splitted into column.

You can use Text-to-columns, using Delimited - when you get to the panel to specify the delimiter, click Other and then in the box do CTRL-J (or you could hold down the ALT key and type 0010 on the numeric keypad), then proceed as usual.

Hope this helps.

Pete

Superb, Yes it perfectly worked indeed.

Thanks a Million.