I am trying to extract the first Initial from a name and combine it with the surname.
So, in A1 i would have Briggs, in B1 would be Joe and in C1 would be J.Briggs, but how do i get the J fron B1?
A B C
1 Briggs Joe J.Briggs
I know how to bring them together using the Concanate formula.
Can anyone help?