Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Swap/Switch First & Last Names In Cell

  1. #1
    Join Date
    24th May 2008
    Posts
    3

    Swap/Switch First & Last Names In Cell

    hello, i need help in interchanging the position of words in a cell with VBA for excel.

    For example, iam having a name " rakesh kumar" in a cell i want to interchange the words about the space and make it to " kumar rakesh".

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd April 2007
    Posts
    3,334

    Re: Interchange

    if "rakesh kumar" is in A1, this formula will return "kumar rakesh"
    =LEFT(MID(A1,FIND(" ",A1&" ")+1,100)&" "&A1, LEN(A1))

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th May 2008
    Posts
    3

    Re: Swap/Switch First & Last Names In Cell

    thank you my friend

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Swap/Switch 2 Rows
    By FRIEL in forum EXCEL HELP
    Replies: 2
    Last Post: April 17th, 2008, 22:05
  2. Switch Cell Values
    By FRIEL in forum EXCEL HELP
    Replies: 6
    Last Post: April 15th, 2008, 17:36
  3. Switch From Find To A Cell
    By adaniele in forum EXCEL HELP
    Replies: 2
    Last Post: June 22nd, 2007, 07:11
  4. Switch Based On Cell In Range
    By zcrucifix in forum EXCEL HELP
    Replies: 9
    Last Post: March 12th, 2007, 08:31
  5. Toggle/Switch Cell Locking/Protection On/Off
    By bdazzler in forum EXCEL HELP
    Replies: 5
    Last Post: September 5th, 2006, 17:14

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
  •  
porno