#HOW REMOVE ALL SPACES IN TEXT EDIT MAC HOW TO#

To turn the new column into an actual list of text, simply select it, hit Ctrl + C, then hit Alt + E + S + V and hit Enter. The new list is, however, just a function and not actual text. You now have a new list next to the old one.

Copy the function in cell B1 down the list by double-clicking the bottom right corner of that cell after you select it and it will be applied to the entire list.

This is because I put a 2 in for the last argument, so only the second occurrence of the space was removed. Notice that the space between the 3 and the c has been removed but the space between the c and the 1 has been left in-tact. Here, I want the second occurrence to be removed so I put a 2. If I put a 1, then the first space will be removed if I put a 2, the second occurrence of a space will be removed. Here, we tell the function which occurrence of 'spaces' we want to remove.

Type a comma to move to the last argument of the SUBSTITUTE function.

Type a comma and then input '' making sure to NOT have anything between the double quotation marks.

Type a comma and then input ' ' making sure to have a space between the double quotation marks.

Select the text from which you want to remove spaces.

Type =SUBSTITUTE( into the cell where you want the text to appear.

This method allows you to remove a specific instance of a space for instance, maybe you need only the second space removed from a list of data. This will turn the SUBSTITUTE function into the text it outputs and you will have your nice new list.

Notice that this has removed all spaces from all of the examples, regardless of how many spaces were in the examples.

To apply this to the entire list, simply double-click the small black square in the bottom right of the cell that you can see when cell B1 is selected in the above image this effectively copies the function down the entire list.

This is what Excel will replace the spaces with, nothing.

Type a comma again to move to the next argument and then type '' making sure that there is NO SPACE between the double quotation marks this time.

This is the part that tells Excel to replace the spaces in the text.

Type a comma to move to the next argument and then type ' ' making sure to include the space between the double quotation marks.

Select the cell that contains the text with spaces.

Type =SUBSTITUTE( in the cell where you want the text without spaces to appear.

Notes Quickly Remove All Spaces from Text in Excel Remove Spaces from Text in a Selection, Entire Worksheet, or Entire Workbook at Once Quickly Remove All Spaces from Text in Excel The methods shown below are easy to use and can be quickly applied to any size list or the entire workbook, which will save you a lot of time. This includes removing all spaces from the middle of text in a cell and removing only certain spaces from the middle of text in a cell.

#HOW REMOVE ALL SPACES IN TEXT EDIT MAC HOW TO#

How to remove spaces from the middle of text in Excel.

How remove all spaces in text edit mac