dashes

  1. R

    Removing Dash from text number string

    We often get spreadsheets from our customer that are formatted with both comma and dash combinations. We would like to only have the comma seperation. Example: R1, R2, R3-R5, R30 Result: R1, R2, R3, R4, R5, R30 There is usually only one alpha character but sometimes more. Example: CR1, CR2...
  2. S

    Can't fully copy links with dashes in them

    With some of my data processing tasks, I'm given an Excel file with many links in column A, and then copy and paste them into a browser. For links that do not have dashes in them, I can just click the link once and it will auto-highlight, allowing me to then just Ctrl + C and move on with...
  3. J

    Seperating numbers on 1 cell to multiple cells

    Hello, I have multiple cells that contain 5 set of numbers that are separated by dashes. Example: 10-11-17-20-26 These set of numbers are on 1 cell only. Exp: A1 I would like to separate these numbers. I would like 10 to be displayed on A1, 11 on B1, 17 on C1, 20 on D1 and 26 on E1. Is...
  4. J

    Need help with replace function in VBA

    Hi All, I'm working with a word table pasted into excel. The dashes in the word table paste into Excel (2003) as small boxes. I can use the find and replace function in Excel and in the Excel environment the replace function works. I recorded the replace function so I could develop the action...

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