How to Replace Spaces in Bulk in Microsoft Excel

Replacing spaces in Microsoft excel is easy, just follow these simple steps and you are good to go! Have questions or need help with a massive e-commerce web store setup? Find Thomas Kane on the team page.

 


 

Use this formula  =SUBSTITUTE(TRIM(A2),” “,”%20”)

  • A2    —- tells us which box to replace spaces in
  • ” ”      —- tells us what character we are replacing i excel
  • %20 —- this could be anything, in this case I am replacing the space with the alpha numeric character that Google considers a space in a URL. You can replace %20 with anything, such as a dash “-” or plus sign “+”


 

Replacing Spaces – The Result

 

 

On 5th October 2012  /   Tips From Our Team  /   Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + 13 =