Results 1 to 2 of 2

Thread: How to remove text and save numbers

  1. #1
    Neophyte Jake Middleton's Avatar
    Join Date
    Sep 2021
    Posts
    3
    Articles
    0
    Excel Version
    2019

    How to remove text and save numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,
    I have attached an example of my document, which I have to edit. My task is to get rid of text in the cells and leave only numbers. What formula should I enter into the cells in column B to solve it?Book1.xlsx

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,721
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Try this:

    =IFNA(-LOOKUP(1,-LEFT(A1,ROW(A$1:A$15))),-LOOKUP(1,-RIGHT(A1,ROW(A$1:A$15))))
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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