Need quick answer simple question

[Beachson]

I have a column of phone number and instead of 1112223333 I would like to make every number look like this (111) 222-3333...how do I do this quickly

 

[Jonmo1]

Try

=TEXT(A1,"[<=9999999]###-####;(###) ###-####")

Then you can copy / paste special / values

 

[c_m_s_jr]

I know it sounds wierd someone just asked me for this and I formatted it but the format is not neccesary all the data is typed in already I just want to put the ( ) and - into them all

If you just want the LOOK of () and - then use the format option in Excel because this will show the () and - but the cell value will remain unchanged, thus keeping the number in tact as a number (I recommend this).

If you want to physically ADD the () and - then use the formula I provided and then copy and paste special values over the column with the 1112223333 (Though I don't recommend this).

 

[scottylad2]

Excel Workbook
	G
14	(289) 847579
15	(289) 847579
16	(289) 847579
17	(289) 847579
18	(289) 847579
19	(289) 847579
20	(289) 847579
21	(289) 847579
22	(289) 847579
23	(289) 847579
24	(289) 847579
25	(289) 847579
26	(289) 847579
27	(289) 847579
28	(289) 847579
29	(289) 847579
Sheet15

If you highlight all your cells, then in the formula bar insert your mouse to where you want the first symbol. Then with the cells still highlighted, go to the insert ribon, then insert special symbol icon (looks like an upside down horse shoe and click on the first side of the parenthesis from the symbols shown. Press insert, then close and then control and enter. All the numbers will have opnbe side now do the same for the second side, and if you want to enter a space do the same and on the symbols menue theres a blank white cell in there. Click on that to add the space, again press insert then close and ctrl and enter to put the space into all your cells.

It's fairly quick way, abount 9 mouse clicks. I got Excel 2007 so not sure where that menu sits in other versions

 

[scottylad2]

The above all sit on one line on my pc, just shows a return on here

 

[scottylad2]

Actuall forget all tha stuff i just typed-if you highlight your data, then in the formula bar just enter the correct symbols and hyphon where you want them and press ctrl and enter it will apply it to all of them. kinda mucks it up as a useable number though after that

Excel Workbook
	G	H
14	(289)-847579
15	(289)-847579
16	(289)-847579
17	(289)-847579
18	(289)-847579
19	(289)-847579
20	(289)-847579
21	(289)-847579
22	(289)-847579
23	(289)-847579
24	(289)-847579
25	(289)-847579
26	(289)-847579
27	(289)-847579
28	(289)-847579
29	(289)-847579
Sheet15

 

[scottylad2]

Excel Workbook
	G	H
14	(289)-847579
15	(289)-847579
16	(289)-847579
17	(289)-847579
18	(289)-847579
19	(289)-847579
20	(289)-847579
21	(289)-847579
22	(289)-847579
23	(289)-847579
24	(289)-847579
25	(289)-847579
26	(289)-847579
27	(289)-847579
28	(289)-847579
29	(289)-847579
Sheet15

i tried posting this and it got stopped.....but just highlight all your cells, in the formula bar add the parenthesis where you want them and a hyphon as well if you want, then ctrl and enter to apply that to all of your data.

 

[scottylad2]

oooops forget that lol