+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,985
    Thank Post
    287
    Thanked 269 Times in 193 Posts
    Rep Power
    115

    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?

    Thanks

    Tim

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Code:
     
    =LEFT(B1,1)
    Last edited by vikpaw; 6th May 2010 at 09:43 AM.

  3. Thanks to vikpaw from:

    timbo343 (6th May 2010)

  4. #3
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,985
    Thank Post
    287
    Thanked 269 Times in 193 Posts
    Rep Power
    115
    Ahhhh

    Thank You!

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    welcome, and sometimes rather than use concatenate function, it's easier to use the ampersand (&) symbol e.g.

    Code:
     
    =left(b1,1)&"."&A1
    Last edited by vikpaw; 6th May 2010 at 10:27 AM. Reason: layout

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula
    By Pumaedition in forum How do you do....it?
    Replies: 6
    Last Post: 8th July 2009, 08:52 AM
  2. [MS Office - 2003] Excel formula?
    By leco in forum Office Software
    Replies: 3
    Last Post: 3rd July 2009, 10:43 AM
  3. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 03:34 PM
  4. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •