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?
Last edited by vikpaw; 6th May 2010 at 09:43 AM.
timbo343 (6th May 2010)
welcome, and sometimes rather than use concatenate function, it's easier to use the ampersand (&) symbol e.g.
Last edited by vikpaw; 6th May 2010 at 10:27 AM. Reason: layout
There are currently 1 users browsing this thread. (0 members and 1 guests)