+ Reply to Thread
Results 1 to 3 of 3

Flip last name and first name using word vba

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    10

    Flip last name and first name using word vba

    Hi,

    flip last name and first name using word vba

    ex :- "Paris, City Of" to "City Of Paris"

    this has to happen only if comma exists in the string.

    Thanks in advance

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Flip last name and first name using word vba

    Hi,

    Use this macro :

    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Flip last name and first name using word vba

    You possibly don't even need a macro for this. What's been described can be done via a wildcard Find/Replace, where:
    Find = (<[! ]@>), (City [Oo]f)
    Replace = \2 \1

    karedog: The question has been posted in the Word forum, so it's probably not much good posting an Excel solution...
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. XY axis flip
    By thisandthat in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-05-2013, 05:49 AM
  2. Flip the code around
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 11:45 PM
  3. Excel 2007 : How to flip row order
    By WolfpackRed in forum Excel General
    Replies: 7
    Last Post: 04-05-2011, 01:58 PM
  4. Flip a specified shape
    By masterxavier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2010, 06:50 AM
  5. [SOLVED] hOW DO i FLIP THE X AND Y AXIS
    By keen learner in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-10-2006, 03:15 PM

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