How to split values from carriage-return from the cell

		Microsoft Office Forums > Microsoft Excel > Excel
How to split values from carriage-return from the cell

FAQ

Thread Tools

Display Modes

11-28-2019, 12:39 PM

NBVC

Windows 10 How to split values from carriage-return from the cell

Office 2016

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove carriage return	abenitez77	Excel Programming	2	04-04-2019 11:41 PM
carriage return on PPT	yangthomson	PowerPoint	0	04-21-2016 07:16 PM
Inserting Carriage Return	rsrasc	Word VBA	4	02-15-2015 11:23 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
Carriage Return Help	UCHelp	Word	1	04-04-2010 10:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.