string divide condition

  1. SantoOnofre

    VBA: Splitting a big string with no good delimiters

    Dear all, I need to split a large string from a single cell, with no good delimiters. It's a 'point-by-point' date from a tennis match, exported directly to an Excel workbook from a third-party software. Unfortunattely, I do not know the VBA language enough to solve this by my own, and I could...
    • SantoOnofre
    • Thread
    • 0-0 6-0 split cell contents string divide condition vba & excel
    • Replies: 1
    • Forum: Excel Questions
  2. R

    Trying to put a variable in a URL to be Hyperlinked. Help please

    So I'm trying to put a variable into a URL that is going to be hyperlinked. if i do a " & Folder1 & " then it simply leaves it out and merges the URL without inputting what is within the variable Folder1. The same goes for Plant and Manifest. What's in red is my problem. Help please. Here's...
    • RooparDE11
    • Thread
    • hyperlink filepath string divide condition variable declaration vba
    • Replies: 1
    • Forum: Excel Questions
  3. M

    String in Column A to be divided into 2 Strings if leght > 50

    Hello All, I have a set of data in Which in column A is the name of organisation. If string in col A is longer than 50 I need to split in and put in col B. That would be simple however I need to do it in a smart manner: i.e. cut it to the nearest full word. Example: THIS EXAMPLE NAME IS TOO...

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