Ever had a bunch of next and numbers in a column and needed to separate them with a space? Follow this guide.
- Find the column you want to add a space to and right click the column heading.
- Left click Format Cells
- Click Custom (bottom)
- 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: ### ####)
- Click Ok to accept changes.
Note: You can preview the changes you make in the preview dialog above the custom edit field.