delete spaces

  1. N

    Deleting Specific Spaces & Subscripting Issues

    Hi there, I have a column with a mix of letters and numbers in each cell and I need one specific number to be subscript, even when there are other instances of that number present (e.g. I need the first 2 in H2-2 subscript but everything else normal case). I tried to target the first 2 by...
  2. N

    Formula to replace data on several tabs

    Hi! I need to replace some data in Excel workbook on several tabs, but cannot figure a formula to cover all tabs. Can someone help? In my Excel I might have the same name (and I know they are really the same eventhough written differently) spelled in various ways like : John Smith John Smith...
  3. H

    Excel Formula Help: Delete Spaces before ever line breaks

    Hi Experts, I am editing over 200k records and I need help with a formula.. I have a lot of texts in every cell with line breaks and there are spaces before each line breaks and these should go away. Can you help? Thanks!

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