Return to Answer

Fixed mistake in formula

Source Link

edited May 21, 2019 at 16:08

This formula works in Excel, assuming no values have commas.

=IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)))-1, LEN(M5RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1))))), "")

Just replace H5 and "material" with the appropriate cell and key.

This formula works in Excel, assuming no values have commas.

=IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)))-1, LEN(M5))), "")

Just replace H5 and "material" with the appropriate cell and key.

This formula works in Excel, assuming no values have commas.

=IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)))-1, LEN(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1))))), "")

Just replace H5 and "material" with the appropriate cell and key.

Source Link

created May 21, 2019 at 15:39

Pizza and Coke

This formula works in Excel, assuming no values have commas.

=IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)))-1, LEN(M5))), "")

Just replace H5 and "material" with the appropriate cell and key.