remove spaces

  1. L

    Eliminate all spaces in a text string

    A fellow worker sent me a spreadsheet full of cells formatted in such a way that it makes it difficult to remove some of the spaces. For testing purposes, here's the file: Uploadfiles.io - remove all spaces.xlsx In this example, I have this text string in cell A1: " 6403 " I want to remove...
  2. S

    How to remove spaces from a cell that displays the results of multiple vlookup functions

    I'm using Excel 2010 on Windows XP. I wish that I could upload the document, but unfortunately it uses lots of sensitive data. Due to the nature of my position, I cannot upload any files from my computer so making a general document and uploading it isn't possible either. :( Below is a copy of...

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