Results 1 to 8 of 8

Retrieve 1st Letters from Full Name

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    Kerala
    MS-Off Ver
    Excel 2007
    Posts
    7

    Thumbs up Retrieve 1st Letters from Full Name

    Hi

    am using MS Office 2007

    I have a column (eg: A) contains NAMES which consists of 1 word name (First name), 2 word names(First name & Last name) and 3 word names (First name , Middle name and Last name).

    Eg.

    Column A
    =======
    Xavier
    xavier jose
    Xavier jose kozhiparambil

    etc....

    i appreciate your help in obtaining result in

    Column B
    =======
    X
    X J
    X J K

    respectively ...... (i.e. X for Xavier; X J for Xavier Joseph; X J K for Xavier Jose Kozhiparambil)
    in B

    with 1 space between all Characters - all CAPS (irrespective of what the source case is)
    Please refer to the Excel file for any clarification.

    Please do help me asap
    Attached Files Attached Files
    Last edited by Accusoft; 04-04-2014 at 11:32 PM. Reason: SOLVED

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Reading the last 2 letters in a combobox value and enter those 2 letters into column
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-26-2013, 09:26 AM
  2. Replies: 12
    Last Post: 01-30-2013, 07:32 PM
  3. Removing leading numbers, letters, full stop, and space
    By Hambone70 in forum Excel General
    Replies: 2
    Last Post: 02-16-2011, 01:09 PM
  4. Retrieve last full week in MS Query
    By gjack72 in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 02:28 PM
  5. How to retrieve full report from Web
    By Calculate Date range in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2006, 06:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1