split cell with wrapped text into two columns

I have a many rows that contain cells with wrapped text; the cell looks like this, for example

laboratory
room a, house a, campus


can I split the information, i.e move "room a, house a, campus" into a separate column.

thanks

apologies, I was not clear; I would like 'laboratory' in one cell and 'room a, house a, campus' in the adjacent cell

Super, thank you to both! I can work with all of these suggestions.

Hi I was wondering if someone could please expand further on this. I am trying to separate an address in to separate columns, which at the momemnt has been wrapped so using the Text to columns is not working.

I have used this formula - =RIGHT(A1,LEN(A1)-FIND(CHAR(10),A1))
which has worked so far in that is has separated each new part away from what went before but it still takes with it what follows it.

For example.

CELL A1 - Address 1, Address 2, City, Postcode
CELL A2 - Address 2, City, Postcode
CELL A3 - City, Postcode
CELL A4 - Postcode

How do I make it so that its:

CELL A1 - Address 1
CELL A2 - Address 2
CELL A3 - City
CELL A4 - Postcode

I'm guessing that it is going to be a slight variation on the formula I have already used. If you have any ideas I would really appreciate your help.

Thanks,

Jen

Hello there,

I have a similar issue whereby I need to split a cell that contains multiple lines, into multiple cells.

What I have is, cell-A1 contains the below:
data1
data2
data3

I need to split them to 3 cells B1, C1 and D1:
Cell-B1 = data1
Cell-C1 = data2
Cell-D1 = data3

I tried the below formula but it is only working for a cell that contains 2 lines..
=RIGHT(D3014,LEN(D3014)-FIND(CHAR(10),D3014))

I really hope someone can help me..

Many thanks,
CSMiin

Hello csmiin, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.