Hi,
Required a formula help to Split a text string values into a parts as required in column C and D, based on data available in column-B.
Sample Sheet and with expected results (Highlighted) are enclosed for the reference.
Thanks for the help.
Hi,
Required a formula help to Split a text string values into a parts as required in column C and D, based on data available in column-B.
Sample Sheet and with expected results (Highlighted) are enclosed for the reference.
Thanks for the help.
Please try spill array
=LET(z,B4:B14,i,FIND("ppm ",z&"ppm "),j,FIND(" 95 ",z&" 95 "),y,SUBSTITUTE(MID(z,IF(i>j,j,i)+4,99),"-D","D"),x,LEFT(y,FIND(" ",y&" ")-1),IF(y={"",""},z,CHOOSE({1,2},x,MID(y,LEN(x)+1,99))))
Many thanks Bo_Ry for your amazing formula solution.
i have an one issue when i added further data to in the text string it is return before spilt text value -(dash sign).
for your reference sample sheet attached.
Try
=LET(z,B4:B22,i,FIND("ppm ",z&"ppm "),j,FIND(" 95 ",z&" 95 "),v,MID(z,IF(i>j,j,i)+4,99),y,MID(v,1+(LEFT(v)="-"),999),x,LEFT(y,FIND(" ",y&" ")-1),IF(y={"",""},z,CHOOSE({1,2},x,MID(y,LEN(x)+1,99))))
Many thanks Bo_Ry for the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks