Forum Discussion
Can't I make the formula so that it will read in order?
syazaaoa95 Perhaps not too complex after all.
Begin by listing of all possible delimiters and create a named range of it. In the example I called it "delim". Then the following formulas will create the LEFT and RIGHT segments.
=TRIM(IFERROR(LEFT([@DESCRIPTION],MIN(IFERROR(FIND(delim,[@DESCRIPTION])-1,999999))),[@DESCRIPTION]))
=TRIM(IFERROR(RIGHT([@DESCRIPTION],LEN([@DESCRIPTION])-MIN(IFERROR(FIND(delim,[@DESCRIPTION])-1,999999))),""))
See attached.
Does this return the intended result?
It helps on the blank one. but for the other conditions, I still can't get the result.
I think my data is not good enough for my intended result. I'll attached add some more there in the excel.
Maybe this is too complex. For example what would be the intended result for this description: Original Sharp Toner Sensor Chip AR-016FT SF1016 SF1018 SF1020
- LEFT
Original Sharp Toner Sensor Chip AR-016FT
RIGHT
SF1016 SF1018 SF1020
That's why I told my boss, that this kind of data is too complex. 😞syazaaoa95 Perhaps not too complex after all.
Begin by listing of all possible delimiters and create a named range of it. In the example I called it "delim". Then the following formulas will create the LEFT and RIGHT segments.
=TRIM(IFERROR(LEFT([@DESCRIPTION],MIN(IFERROR(FIND(delim,[@DESCRIPTION])-1,999999))),[@DESCRIPTION]))
=TRIM(IFERROR(RIGHT([@DESCRIPTION],LEN([@DESCRIPTION])-MIN(IFERROR(FIND(delim,[@DESCRIPTION])-1,999999))),""))
See attached.