Microsoft Office Forums - View Single Post - How to split values from carriage-return from the cell

Thread: How to split values from carriage-return from the cell

View Single Post

Old

11-28-2019, 12:39 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2016

NBVC uses Office 2016

Office 2016

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Try:

="<opt mfr="""&LEFT(L5,FIND(CHAR(10),L5)-1)&""" pnv="""&LEFT(K5,FIND(CHAR(10),K5)-1)&"""/>" &CHAR(10)&"<opt mfr="""&MID(L5,FIND(CHAR(10),L5)+1,255)&"""pnv="& MID(K5,FIND(CHAR(10),K5)+1,255)&"""/>"

copied down

Format the result cells by Wrapping text

Reply With Quote