extract text in cell

  1. DRSteele

    Remove Unwanted Characters from a Textstring

    Getting rid of unwanted characters in a cell's textstring can be achieved easily by creating a Table of acceptable UNICODEs and their corresponding UNICHARs. The Table (here named T_codes) can be expanded or contracted as needed. Here, we have just the usual set of English letters (26 Upper Case...
  2. Z

    Extract 1-N value(s) from a string of text in 1 cell - multiple extraction values in separate tables (excel formula needed)

    Thank you in advance for the help! ? After extensive forum research, I decided to post since I was unable to find a comparable problem/solution. Summary I need a formula that can extract a value from within a string of text based on a list of multiple criteria to look for (e.g. if value 1, 2...
    • zen
    • Thread
    • data transformation extract text in cell formula nomenclature sku generator skus transformation
    • Replies: 1
    • Forum: Excel Questions
  3. H

    Pulling text after finding its relative position

    Dear all, I am stuck trying to automate a report which contains long strings of data with about 60 different country codes variants. I have a column text based which is inconsistent, for example: 1) GUIDE, Paper congress 2564 US Zii 2) Geni Radio DOC RU, Team template What I need to do, is to...

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