+ Reply to Thread
Results 1 to 4 of 4

chop 1 right chop 1 left

  1. 07-21-2014, 01:03 PM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    chop 1 right chop 1 left

    Suppose i have O17A on cell a1

    Need 17 on cell b1 through one formula
    Reply With QuoteRegister To Reply
  2. 07-21-2014, 01:13 PM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: chop 1 right chop 1 left

    =mid(a1,2,len(a1)-2)
    try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 07-21-2014, 01:15 PM #3
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: chop 1 right chop 1 left

    This should do it;

    =MID(A1,2,LEN(A1)-2)
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.
    Reply With QuoteRegister To Reply
  4. 07-21-2014, 01:18 PM #4
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: chop 1 right chop 1 left

    Thanks same working answer , same time
    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)

Similar Threads

  1. [SOLVED] Chop all data and give me this only
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-07-2014, 08:05 AM
  2. CHOP rows into some Excel files
    By thesti in forum Excel General
    Replies: 4
    Last Post: 01-09-2010, 08:38 PM
  3. How do i chop up a spreadsheet
    By John K in forum Excel General
    Replies: 3
    Last Post: 12-07-2006, 11:51 AM
  4. [SOLVED] chop off extra characters in excel
    By [email protected] in forum Excel General
    Replies: 6
    Last Post: 06-21-2006, 11:25 PM
  5. Chop off parts of the statement
    By 0-0 Wai Wai ^-^ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2006, 05:10 AM

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