help me split into two rows

lochness8

New Member
Joined
Feb 27, 2019
Messages
1
I have hundreds of rows like these. I would like to break up this row into two rows.
I have (soft return inside cell)

CHEM-120MW W11:10AM 7:50AM12:35PM 11:00AMW222 E237Diane,
Joe
01/28/201905/24/2019

<tbody>
</tbody>


I would like it to be on separate rows:

CHEM-108-9107MW 11:10AM 12:35PM W222Diane 01/28/201905/24/2019

<tbody>
</tbody>
CHEM-108-9107W 07:50AM 11:00AM E237Joe 01/28/201905/24/2019

<tbody>
</tbody>

Any suggestions on how to do this in excel? will i need VBA?

Thanks!

****** id="cke_pastebin" style="position: absolute; top: 185.6px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">05/24/2019

</body>
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

wist

Board Regular
Joined
Nov 8, 2012
Messages
79
copy the column where you have more lines in one cell -> paste to notepad (I assume the cell with will be pasted in quotation marks) ->replace quotation marks for nothing-> copy data from notepad -> paste to word -> replace spaces for line breaks "^p" -> copy data from word -> paste back to excel

should work if you have spaces between the lines ..if you have them between other words you dont want to replace its a bigger issues ..if you dont have spaces at all there you will have to find some other character that you could replace i.e. if you have something like "12:35PM11:00AM" you could replace M for M^p
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,292
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top