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, 09: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, 09:26 AM #2
Last edited by vikpaw; 6th May 2010 at 09:43 AM.
6th May 2010, 09:39 AM #3
6th May 2010, 09: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 10:27 AM.
By Pumaedition in forum How do you do....it?
Last Post: 8th July 2009, 08:52 AM
By leco in forum Office Software
Last Post: 3rd July 2009, 10:43 AM
By denon101 in forum How do you do....it?
Last Post: 1st December 2008, 03:34 PM
By RabbieBurns in forum Windows
Last Post: 13th August 2008, 05:31 PM
By DSapseid in forum Windows
Last Post: 7th November 2007, 04:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)