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

micky running
micky running used Ask the Experts™
on
HAVE 4 letters ABCD
how can a just select the positon AC or  AD ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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
Top Expert 2015
Commented:
Hi

try  left (text , number of characters) & Mid ( text, start_position, number_of_characters )

to get AC
Left ( ABCD, 1) & Mid ( ABCD, 3,1)

To get AD
Left ( ABCD, 1) & Mid ( ABCD, 4,1)

Author

Commented:
GOOD TO GO!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial