Forum Discussion
Solved
Column Split by Last Delimiter.
Hi, I need to split column by last delimiter. Pls see the below example. Any help is highly appreciable. Thanks. I need the last set of my Project numbers which has no fixed length.
Let's say the values are in A2 and down.
Enter the following formula in another cell in row 2, for example in B2:
=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",255)),255))Fill down.
You may extract by
=FILTERXML("<t><s>" & SUBSTITUTE(A2,"-","</s><s>") &"</s></t>", "//s[last()]")sample:
SergeiBaklan
Hi, I've just come across your formula and it is exactly what I need for one piece of work. Thanks! My next questions are 1)could you explain the components so I understand? and 2) How could I change it for prefix?