Results 1 to 4 of 4

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

  1. #1
    Junior Member
    Join Date
    Feb 2014
    Posts
    2
    Rep Power
    0

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

    I want an excel formula who combine first and last 3 letters of a text.

    For an example:-SPPADRKCCRCRD
    the formula should show me as 'SPPCRD'.

    Regards

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    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)

  3. #3
    Junior Member
    Join Date
    Feb 2014
    Posts
    2
    Rep Power
    0
    Thanks for a lot.Glad to find the nice solution.

    Regards

  4. #4
    Junior Member
    Join Date
    Dec 2013
    Posts
    2
    Rep Power
    0
    Enter the formula:
    =LEFT(E2,3)&RIGHT(E2,3) ,replace E2 with the cell when the text is on

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. Replies: 10
    Last Post: 11-21-2013, 04:41 PM
  3. 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •