Find character in string

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Tobacco Outlet #1
TRO #1
Tobacco Road Outlet #1
Needs to return 1
Tobacco Outlet #1201
TRO #1201
Tobacco Road Outlet #1201
Needs to return 1201
 
In all cases you are looking for the number after the #.

MyString = "Tobacco Road Outlet #1201"
MyNumber = val(mid(MyString,instr(MyString,"#")+1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find character in a string 6
Help with Right(Me.ListStoreIP.Column(0), 2) 3
Sort, Select and Avg Macro 8
Averaging specific rows - HELP! 5
Sort, select and average macro help 2
Formula returns #N/A 1
Rearranging a Very poorly constructed list 6
For every empty cell in a column, copy the value from the above ce 3

Back
Top