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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:27 AM.