textsplit

  1. R

    TEXTSPLIT into Rows but Maintain Grouping

    This is harder to explain than show. I have metadata being imported into an Excel spreadsheet that defines a single item (an image title) on a given row, but much of the metadata is in separate columns with each column cell containing data that is separated by delimiters (;). These are all...
  2. H

    Calculation With Numbers Separated By Hyphen

    I have a sheet which records football results. Without using a helper column, is it possible to calculate the difference in scores listed as such...1-2, 2-3, 0-0 and so on? I need to be able to do the following:- If the away team's score is 2 or more greater than the home team, it is a W...
  3. P

    Array to return Multiple Results (maybe byrow function)

    I am trying to use Textsplit with byrow to return multiple results, but I am getting a CALC error. Ignore the name error. This is my personal computer. The ":" is the delimiter. AB1Product21800:940032400:250045#NAME?67Result I would...
  4. M

    Extracting text string from cell with no delimiters

    Hi See sample data: ABCDEFGHIJKL1Product CodeOrderOrdered PartsIntended...
  5. R

    TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions

    Hi Friends, I am using Office 365 and the TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions not available in my excel. if i type =TEXT in my excel i could only TEXT and TEXTJOIN function. So, please let me know how do i make in work in my Excel. Thanks for all your help in advance. Regards, Ranjith

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