ExcelBanter - Find character in string

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find character in string (https://www.excelbanter.com/excel-programming/406399-find-character-string.html)

Mike

Find character in string

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

joel

Find character in string

In all cases you are looking for the number after the #.

MyString = "Tobacco Road Outlet #1201"
MyNumber = val(mid(MyString,instr(MyString,"#")+1))

"Mike" wrote:

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

All times are GMT +1. The time now is 02:00 PM.