access formula for an excel formula

  • Thread starter Thread starter tricia
  • Start date Start date
T

tricia

ow do this in access
=RIGHT(A3,LEN(A3)-FIND("\",A3,FIND("\",A3,FIND("\",A3)+1)+1))

A3 being a field in access
 
What is it you're trying to accomplish? This formula won't work in Excel as
the outermost find is being given too many arguments (as is the first nested
find).

For example, if you have the text:

"Today\Is\Great"

What would you want the function to return?
 
Great

Gummball said:
What is it you're trying to accomplish? This formula won't work in Excel as
the outermost find is being given too many arguments (as is the first nested
find).

For example, if you have the text:

"Today\Is\Great"

What would you want the function to return?
Click to expand...
 

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

excel formula 1
Need to migrate phone no into the next record if the family 1
Change Color of cell 3
formula question 1
export query with formulas to excel 2
Search substring in a string 4
Greater Than Symbols and calculations 0
IF function in Query 2

Back
Top