Geek Answers Handbook

How to find a character at a specific index in a given cell?

I was wondering if there is a function in Excel that will return a character with a given index of a single cell.

For example, I have a cell that says HELLO. I am looking for a function (or a combination of functions) that will allow me to return any character to index 2, which is, if the index of the Excel cell does not start with 1, not 0, L.

I am really looking for an Excel function that is similar to the charAt () method in Java.

In addition, I know that I could use the = left function to return all the characters to a specific point in the cell, but I just need one specific character at one specific point returned to the cell.

Please let me know if you need me to understand more.

+6
source share
1 answer

As the comments suggest, this works:

=MID(A1,2,1)
+4
source

More articles:


All Articles