+ Reply to Thread
Results 1 to 2 of 2

Move Name title to another column.

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    1

    Move Name title to another column.

    I have a huge database which i usually convert to excel file.

    here is the problem now. For the names, i have a column lets say b

    MR Rais Azad
    Dr Rais Azad
    MS Sophie
    MISS Sophie

    I have a set of title and Academic title in German.
    ---------------
    Frl.
    Ing.
    Frau
    Dipl. Ing.
    Herr
    Dipl.-Kfm.
    Familie
    Mag.
    Dr.
    Dres.
    Priv. Doz.
    Prof.
    Gräfin
    Graf
    ---------------

    I want to have a function which can, first find and match the above titles and if match- move them to the col A

    Giving me something like this:

    MR Rais Azad
    Dr Rais Azad
    MS Sophie
    MISS Sophie

    Please let me know if there is something which can help me to fix this.

    Thank You

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Move Name title to another column.

    use the find function find the first space, then trim the data with the left and right formula
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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