+ Reply to Thread
Results 1 to 3 of 3

Separate last two words

Hybrid View

  1. 03-03-2012, 11:18 AM #1
    hatwarvaibhav
    hatwarvaibhav is offline
    Registered User
    Join Date
    03-03-2012
    Location
    gondia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Separate last two words

    i have no of record i don't know how to separate last two word.plz tell me.
    Reply With QuoteRegister To Reply
  2. 03-03-2012, 12:46 PM #2
    mahju
    mahju is offline
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: how to saparate last two word

    Hi
    I think you mean last two alphabet
    If a1 contains the data use

    =Right(a1,2)

    If it is not correct give some examples


    Regards
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju
    Reply With QuoteRegister To Reply
  3. 03-21-2012, 10:57 AM #3
    hatwarvaibhav
    hatwarvaibhav is offline
    Registered User
    Join Date
    03-03-2012
    Location
    gondia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Separate last two words

    HI
    I Wan to to separate RM16 6BE (135 Mayflower Road, Chafford Hundred, GRAYS, Essex, RM16 6BE) from this line plz tell me how i do it
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1