extract text and numbers

  1. E

    Extracting Text

    I try to stay away from asking questions on this forum as much as possible but I would really appreciate help on finding a solution to a problem! I'm looking to extract the numbers (one, two or three digits) between certain text/characters. Example assuming the cell is A2: The formulas would...
  2. K

    extracting infomation from parenthesis when there are 2 sets within a string....?

    I need to extract only the data within the last set of parenthsis. Here is my text. <TBODY> Customer (Central) (SS01) I used this formula::: =MID(A7,FIND("(",A7&"(")+1,SUM(FIND({"(",")"},A7&"(0)")*{-1,1})-1) and I returned the first text string. "central" Please advise on how to...
  3. D

    Replacing Alpha Characters (english + non english) with single space.

    Hi, Looking for an easy solution to my data, which have cells consisting Numbers, alpha characters, symbols, again numbers. The location of numbers are not fixed, and sometime there is alpha characters , numbers, alpha characters, numbers, ... Question: how can i replace all the alpha...
  4. T

    Parse text from HTML text block to multiple columns

    Hello everyone, I have a .csv export file that contains description fields like the following (in A1): <table border="0" cellpadding="0" cellspacing="0" width="383" height="160"><col width="383"><tr height="160"> <td class="xl63" style="height: 120pt; width: 287pt;" width="383"...
  5. A

    Extract text and numbers

    I want extract numbers and text from LAXMI GANPATI ENTERPRISES19.475 In column one LAXMI GANPATI ENTERPRISES In column Two 19.475 BALAMURLI ENTERPRISES 19.11 tks in advance

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top