Formula Query

K

kapkase

New member
Joined
Jul 22, 2016
Messages
2
Reaction score
0
Points
0
I am not sure if there is a formula for what I am trying to achieve so any assistance or guidance would be greatly appreciated. I should add, in all the searching that I have been doing, where I have come unstuck would be using the correct terminology - so I hope this makes sense;

Say cell A1 contains "ABCDEFGH", is there a formula (I could enter into B1) that will single out a specific character based on it's numerical order and show it?

eg: (for this example, say the specific character is the 7th character)
AB
1ABCDEFGHG
2
 
Last edited:
kapkase said:
eg: (for this example, say the specific character is the 7th character)
Click to expand...
If you want to find the position of the seventh character then use the following formula
Code: 
=MID(A1;7;1)

If you want to find out what the position is in the order of a certain character options exist then the following formula
Code: 
=FIND("G";A1;1)
or
=SEARCH("G";A1;1)
=SEARCH("g";A1;1)
FIND function is sensitive to uppercase and lowercase
SEARCH function is not sensitive
 
navic said:
If you want to find the position of the seventh character then use the following formula
Code: 
=MID(A1;7;1)
Click to expand...

This is exactly what I have been searching for. Thank you Navic - you've helped me immensely.
 
You must log in or register to reply here.
Back
Top