Hello
I have data as shown.
I need VB COde to do following
Look for 2 "#" in text in Column E.
Example will be "06/07/21 Check #x1126 #9112"
Now add last digit from #x1126 to #9112
So you will have
"06/07/21 Check #x1126 #91126"
Now take digit part of #91126 and put in column D same row.
I have manually done this as shown in yellow highlighted in column D.
Please let me know if you have any questions.
Thanks.
R
Bookmarks