Office Software Thread, Excel Formula Help in Technical; I am trying to extract the first Initial from a name and combine it with the surname.
So, in A1 ...
6th May 2010, 10:25 AM #1
Excel Formula Help
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?
IDG Tech News
6th May 2010, 10:26 AM #2
Last edited by vikpaw; 6th May 2010 at 10:43 AM.
6th May 2010, 10:39 AM #3
6th May 2010, 10:42 AM #4
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 11:27 AM.
By Pumaedition in forum How do you do....it?
Last Post: 8th July 2009, 09:52 AM
By leco in forum Office Software
Last Post: 3rd July 2009, 11:43 AM
By denon101 in forum How do you do....it?
Last Post: 1st December 2008, 04:34 PM
By RabbieBurns in forum Windows
Last Post: 13th August 2008, 06:31 PM
By DSapseid in forum Windows
Last Post: 7th November 2007, 05:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)