My Profile Photo

luke.geek.nz


An IT Engineer with a love for all things IT including (but not limited to), Microsoft Azure, Automation and Service Management!


Excel – Add a space in a column of data.

Ever had a bunch of next and numbers in a column and needed to separate them with a space? Follow this guide.

  1. Find the column you want to add a space to and right click the column heading.
  2. Left click Format Cells
  3. Click Custom (bottom)
  4. Now work out how many letters/words you want before a space and type: # for each character, press Space where you want a space to be and then type the rest of the # (for example for a NZ telephone number it would look like:  ### ####)
  5. Click Ok to accept changes.

Note: You can preview the changes you make in the preview dialog above the custom edit field.

comments powered by Disqus