#1
|
|||
|
|||
How to split values from carriage-return from the cell
Hi folks,
I need the help to split values from cell values which separated using carriage-return/hard return as follows: for instance, the cell contains like, case 1: case 2: cell K: cell L: or cell K: cell L: abcd123785 53618 abcd123785 53618 bnsertsg1237 24515 bnsertsg1237 I need the conversion in other cell like, case 1: <opt mfr="53618" pnv="abcd123785"/> <opt mfr="24515" pnv="bnsertsg1237"/> case 2: <opt mfr="53618" pnv="abcd123785"/> <opt mfr="" pnv="bnsertsg1237"/> Please help me out on this... Thanks ganesan. g Last edited by ganesang; 11-27-2019 at 09:24 PM. Reason: attachment added |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thanks for the reply
Can you please help me more on this.... as follow if i have the data like in cell k have three values and cell l one value how can call cell l value to all cell k values "<opt mfr=""09021"" pnv=""RK73H2HL **4991F""/> <opt mfr=""09021""pnv=CRCW20104K99FKTF""/>" also i have the values in cell K sometimes more than one, in this case will take cell l value |
#4
|
||||
|
||||
Can you post the sample with expected results in an excel file?
|
Thread Tools | |
Display Modes | |
|
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 |