converting

  1. E

    How to convert rows of Excel addresses into a single column in Word?

    This is what I have in Excel, rows of addresses: John Doe | 123 Anystreet | Anytown, NY 12345 Mary Doe | 123 Anystreet | Nowhere, NY 22333 This is how I want it to appear in Word, a single column of addresses: John Doe 123 Anystreet Anytown, NY 12345 Mary Doe 123 Anystreet Nowhere, NY...
  2. E

    How to convert single column of addresses in MS Word into 3 columns in MS Excel

    I have a list of addresses in MS Word, in a single column, such as John Doe 123 Anystreet Anytown, NY 12345 Mary Doe 123 Anystreet Nowhere, NY 22333 etc I want to convert each vertical address in Word into a horizontal address in Excel so it looks like this in 3 columns: John Doe | 123...
  3. 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...

This Week's Hot Topics

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
Top