FIND

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

What is the replacemnt for "FIND" in this line:

=LEFT(A2,IF(ISERROR(FIND(",",A2,1)),LEN(A2),FIND(",",A2,1)-1))

to create an update query?
 
If you are looking for the Access equivaliate the try this --
InStr(A2,",")
 
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

Use & with two formulas 2
Separate first name, middle name and last name 2
Changing Cell Reference in Formula 5
Make them work on the Each cell Value 7
Right Text - Variable Find 2
value time formula help please 4
formulas for conditional formatting 5
Excel Catagorise AM or PM 7

Back
Top