Comments on: How to remove text and leave numbers in Excel or vice versa

Comments page 2. Total comments: 52

1. 

   todd says:
   2022-03-28 at 8:32 pm

   Hi, I'm using the RemoveText custom function but it doesn't preserve decimals. For example, 950.43 becomes 95043. Is there a way to save the decimals?

   1. 

      Alexander Trifuntov (Ablebits Team) says:
      2022-03-29 at 7:55 am

      Hello!
      The comma is considered a character, not a number. Therefore, it must be added to the list of symbols that are not removed.
      VBA code 2:

      .Pattern = "[^0-9\,]"

      You can also use regular expressions to remove specific characters from text. Here is a detailed instruction: Excel Regex to remove certain characters or text from strings.
      In the RegExpReplace function, use the pattern "[^0-9\,]"

2. 

   AEJ says:
   2022-02-14 at 10:38 pm

   Thanks! That worked perfectly!

3. 

   Evan says:
   2021-12-22 at 4:18 pm

   Hello,

   It's the perfect solution. How to make an empty cell for the blank cell? Since we drag the formula down, the empty cell grabs some wired string and special character.

   Thank you!

   1. 

      Svetlana Cheusheva says:
      2022-03-29 at 9:34 am

      Hi Evan,

      Nest your formula in the IF function like this:

      =IF(A2="", "", your_formula)

      Where A2 is the cell with the original data.

4. 

   Jodi says:
   2021-11-18 at 9:33 pm

   Hi Svetlana,
   This is such a cool example; thank you for providing it. In my data I am trying to pull out numeric value from my text which is listed for example as 70 MPH. There could be other numeric values after the MPH but I dont want those. Can this formula be adjuster to only pull the numberic value before MPH? Thanks!

   1. 

      Svetlana Cheusheva says:
      2021-11-19 at 8:19 am

      Hi Jodi,

      If you are looking for a universal solution that can pull number before any text, please see How to extract number from the beginning of text string.

   2. 

      Alexander Trifuntov (Ablebits Team) says:
      2021-11-19 at 7:16 am

      Hello!
      Try to substitute this expression in the formula instead of A2:

      LEFT(A2,SEARCH("MPH",A2)-1)

      I hope it’ll be helpful.

5. 

   Sukumar says:
   2021-07-24 at 8:42 am

   Hi Svetlana,

   what is the software you use to highlight your images in all your articles?

   Kind regards

   1. 

      Svetlana Cheusheva says:
      2021-07-26 at 9:10 am

      Hi Sukumar,

      It's FastStone Capture.

      1. 

         Sukumar says:
         2021-08-02 at 7:16 am

         Thank you
         Regards