splitting text

  1. D

    Splitting Text to Multiple Cells

    This may be a dumb question but here goes! I purchased Allen Wyatt's ExcelTips and was trying to implement a User Defined Function referenced there for Splitting Text to Multiple Cells. I copied and pasted the code into my VBA Module. When I use the function and enter the parameters, I see...
  2. T

    Splitting Text

    Text functions were never my specialty, but I am looking to create a lookup table for another worksheet based on the below information. I would like the numbers on the left side of the cell before the " -- " in the middle in one cell (say A2), and then the name on the other side of the " -- " in...
  3. T

    Splitting text

    Good day I have a string of text that I am trying to split and make into multiple rows. The text isnt the same length and changes from cell to cell. An example of a couple rows of what I have is <TABLE style="WIDTH: 271pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...
    • Tsch
    • Thread
    • splitting text text conversion text to rows
    • Replies: 12
    • Forum: Excel Questions

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