string of text

  1. J

    Remove Text and Numbers from a cell

    Hello, I received a file that has text, numbers, and some more text in a string and I would like to break it out into 3 columns. Each cell contains a name, phone number, and email address, all in the same cell. Example: Tony Smith 123-456-7890 tony@smith.com William Williamson 234-567-8901...
  2. K

    Pull string of text from within a cell

    I need a formula that I can copy down to pull a string of text from within cells. for example, I have the following text in a cell: <tbody> 44. 78. 9745016. 4. A SXYF JNMOPLATED XYZZ 4OZ 1PK I want to pull 9745016 from within that cell. This string is 7 digits long. In addition I...
  3. malvdh

    Formula to look X cells to right then up to keyword - Step 1

    Hello all, (Excel 2007 user) I have a spread sheet that has data dumped into one column. I need to assign each row of each page the corresponding Fund and Account number. There are keywords that can be used to search and capture. Each page has a keyword, lets say TopOfPage. The Fund number...

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