Finding a Character in a string

  • Thread starter Thread starter Mitch
  • Start date Start date
M

Mitch

In excel I use the following funtion to located the "@"
character in an email address:
=FIND("@",A2,1) , where cell A2 contains the email address

The find function is not available in Access, is there
something else I can use?
 
Mitch said:
In excel I use the following funtion to located the "@"
character in an email address:
=FIND("@",A2,1) , where cell A2 contains the email address

The find function is not available in Access, is there
something else I can use?
Click to expand...

Check Help file for InStr() function.
 
Back
Top