extracting text

  1. DPChristman

    Extracting names from either side of a comma

    This is something I thought I knew how to do, but it isn't working. I have a column in my spreadsheet with names in the Lname,Fname cormat (Example: Smith,John A) Say this data appears in cell A2. I thought the way to get is was <=RIGHT(A2,(FIND("",A2,1)-1))&" "&LEFT(A2,(FIND(",",A2,1)-1)) >...
  2. F

    Extracting Data From Multiple Sheets into 1 Sheet

    I'm working with multiple worksheets in one workbook and want to find a way to extract data from the multiple tabs into one sheet. Each tab has different headers, see below. I only want to pull out certain data. Each worksheet would be updated weekly. TAB 1 HEADERS: <tbody> Shoot Date Air...
  3. K

    Extracting numbers

    Hello, Please help me build a formula for extracting the number from text below: <tbody> IHB_PO :U100/0000102029/2017 I just need to extract 102029 from above. Regards Sunil </tbody><colgroup><col></colgroup>
  4. B

    Using FIND in Extracting Text Strings

    I have a text string that I need to make multiple extractions from. I've managed to make use of MID & FIND in extracting what I want, only I'm getting too much. How do I delete the remainder of the text? Text string...
  5. K

    Extracting string from a cell

    Hi, Does anybody has a formula in excel/function in VBA handy which I can use to extract Base from the text string below : <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> Ps_Base_AF.xlsx Thanks, ks1987 </TBODY>
  6. T

    Create a macro that will extract the text that is between "Start" and "End" blocks

    Hi, I have a structure of text in Excel which I imported from the ICalendar. I have blocks of text that I would like to extract. Below is an example. Can anyone help? Thank you , Tamir <colgroup><col></colgroup><tbody> Start 01/01/2013 text text tet text text text tet text text text...
  7. Y

    Extracting parts of string seperated by "/" and copying them into adjacent rows

    I have a large spreadsheet with a string in column A that I need to split into six parts. Each part is identified by a "/" Example of the string : ID No / Item / Size / Colour / Comments / Type / I need to extract each part of the string and copy it into adjacent cells in the same row ID in...

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
Back
Top