In A1 Cell
Text text text bla bla ##200100
In B1 Cell
Formula:
=IFERROR(MID(A1,FIND("#",A1)+2,FIND(" ",REPLACE(A1&" ",1,FIND("#",A1),""))-1),"")
In A1 Cell
Text text text bla bla ##200100
In B1 Cell
Formula:
=IFERROR(MID(A1,FIND("#",A1)+2,FIND(" ",REPLACE(A1&" ",1,FIND("#",A1),""))-1),"")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks