+ Reply to Thread
Results 1 to 4 of 4

How to remove 7 and 8 number character from cell A1 character start from left to right

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    How to remove 7 and 8 number character from cell A1 character start from left to right

    Dear all, i have two cell, A1 is input and B1 is output. how to remove 7 and 8 number character from cell A1,
    character start from left to right , please check the bellow example.
    CELL A1 > CELL B1
    2010-6-1-A-100 > 2010-6-A-100
    2011-7-2-A-2 > 2011-7-A-2
    2012-8-3-A-3 > 2012-8-A-3
    2010-6-1-A-4 > 2010-6-A-4
    2011-7-1-A-5 > 2011-7-A-5
    2012-8-1-A-6 > 2012-8-A-6
    ............................
    ............................

    for example:
    character 12345678
    2010-6-1-A-1
    so if i count from left to right, i want to remove 7 and 8 number charecter all time

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to remove 7 and 8 number character from cell A1 character start from left to right

    Try:

    =REPLACE(A1,7,2,"")

    - Moo

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: How to remove 7 and 8 number character from cell A1 character start from left to right

    Dear Moo,
    It works perfectly for me , I appreciate you job . thanks…..br/nur

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to remove 7 and 8 number character from cell A1 character start from left to right

    You're welcome. Glad I could help

    - Moo

    - - - - - - - - - -
    If you are satisfied with the solution(s) provided, please mark the thread as [SOLVED] by clicking on the words 'Thread Tools' above your 1st post in this thread. Then select 'Mark Thread as Solved'.

    Also, a good way to 'Say thanks' to those who have helped is to click on the star below their name in one of their posts. It's always appreciated.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1