Home // Blog & Excel Tips // Adding hypens into a group of telephone numbers

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Adding hypens into a group of telephone numbers

Comments Closed
Uncategorised

A recent question asked
Regarding a column of phone numbers that have been entered without hyphens… Is it possible to highlight the column and put hyphens into the numbers e.g. from 3105551212 to 310-555-1212? If not, is it possible to actually color the middle section of the numbers e.g. the 555 colored so that the 310 stands out as well as the 1212 because they are not highlighted. I am looking for quick way to make the numbers easier to dial because I am receiving spread sheets without the hyphens in the spread sheets.

Couple of options. You can look at the video clips about the LEFT RIGHT MID functions  and then the Concatenate function to see how to add the hyphens. Another alternate is to use the format option to make spaces.