Find character position in a string for IF statement

[JIM456]

This is hopefully simple! But not for me! I have a series of account numbers in the format xxxx-xxx, where I need to extract the 5th character (ex 6005-201, in this case the "2") in order to use in an IF Statement. One final note, the 6005-201 exists as a formula; do I have to value it as text?

Please help!


Thanks,

Jim

 

[Joe4]

Are they ALWAYS in the format of "xxxx-xxx"?
Are they by themselves, or part of a larger string?

If by themselves, try using:
=MID(A1,6,1)
where A1 is whatever cell the value is in.

If they are parts of larger strings, can you post some examples that cover the array of different string structures they may be in?

Also, what exactly does the formula look like?
It may be even simpler to pull from the same spot the formula is.

 

[JIM456]

Are they ALWAYS in the format of "xxxx-xxx"?
Are they by themselves, or part of a larger string?

If by themselves, try using:
=MID(A1,6,1)
where A1 is whatever cell the value is in.

If they are parts of larger strings, can you post some examples that cover the array of different string structures they may be in?

Also, what exactly does the formula look like?
It may be even simpler to pull from the same spot the formula is.

THANKS! That works.

 

[Joe4]

You are welcome!
Glad I was able to help.