Good day.
I know how to basically do an index match search. However, I am stumped on how to extract the first, 2nd, 3rd, 4th and fifth letters of the returned value.
A sample is attached below. I need to be able to enter the ID number and then generate the FIRST NAME INITIALS of the returned value. Any help will be much appreciated.
I know how to basically do an index match search. However, I am stumped on how to extract the first, 2nd, 3rd, 4th and fifth letters of the returned value.
A sample is attached below. I need to be able to enter the ID number and then generate the FIRST NAME INITIALS of the returned value. Any help will be much appreciated.