Results 1 to 4 of 4

Thread: Required an excel formula to combine first and last 3 letters of a text

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-07-2014, 12:16 PM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Pradeep,

    Welcome to board !!

    if your text is in A2, in B2:

    =IF(LEN(A2)>3,LEFT(A2,3)&RIGHT(A2,3),A2)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 03-07-2014, 12:56 PM #2
    PRADEEPB270
    PRADEEPB270 is offline
    Junior Member
    Join Date
    Feb 2014
    Posts
    2
    Rep Power
    0
    Thanks for a lot.Glad to find the nice solution.

    Regards
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. COMBINE AND OR with IF Function in Single Formula
    By analyst in forum Excel Help
    Replies: 4
    Last Post: 03-26-2014, 05:17 PM
  2. Excel Macro to populate the values in the required cells
    By pbabu in forum Excel Help
    Replies: 10
    Last Post: 11-21-2013, 04:41 PM
  3. Absolute amount or IF and Greater than Formula Code Required
    By aaron.mendes in forum Excel Help
    Replies: 1
    Last Post: 07-23-2013, 10:43 PM
  4. VBA Program to Compare 4 Columns in Excel (Required)
    By vijaysram in forum Excel Help
    Replies: 11
    Last Post: 06-26-2013, 10:53 AM
  5. Excel Formula To Extract Values From Text
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 08-22-2012, 09:05 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
  •  

Forum Rules