Link to home
Create AccountLog in
Avatar of micky running
micky running

asked on

Have 4 Letters field Like ABCD but just need AC how can do it?

HAVE 4 letters ABCD
how can a just select the positon AC or  AD ?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Define "Position"....

In other words, ...for the text you provide, what do you want the result to be?

The position of a "A" wold be:
Instr(YourString,"A")
...will return: 1

Instr(YourString,"D")
...Will return 4
ASKER CERTIFIED SOLUTION
Avatar of Kanti Prasad
Kanti Prasad

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of micky running
micky running

ASKER

GOOD TO GO!