IF contain # in a text extract the full number coming after it
Dear all,
perhaps someone can help me with this.
I wish to extract the number after the ## and add it to the next column. The number will change (as well as lenght), and it can be in the beginning, middle or end of a sentence.
(A1) Text text text bla bla ##200100 --> (B1) 200100
(A2) Text text text ##201280 text text --> (B2) 201280
(A3) Text text ##200190200210213410 text text --> (B2) 200190200210213410
Many thanks,
Nanda
In A1 Cell
Text text text bla bla ##200100
In B1 Cell
Formula:
Please Login or Register to view this content.
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
Pls try this file as well.
Please click 'Add reputation', if my answer helped you.
Amazing!Mant thanks to both of you! great help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks