@
@Homeonthecouch
Hello
I am wanting to capture a certain letter in a string of letters say a name.
I would like to say have a name entered in cell A1.
From there I would like to capture the first letter in cell B1.
In cell C1 I would like to capture the 3rd letter.
So, A1 would have Smith Input
and
Cell B1 would be S
Cell C1 would be I
Is there a formula?
I am wanting to capture a certain letter in a string of letters say a name.
I would like to say have a name entered in cell A1.
From there I would like to capture the first letter in cell B1.
In cell C1 I would like to capture the 3rd letter.
So, A1 would have Smith Input
and
Cell B1 would be S
Cell C1 would be I
Is there a formula?