Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() Hi I'm stuck on this one I want to add a 1 to my phone list. I have removed all spaces and other signs to create a number such as from (201) 276-2143 to 2012762143 Now I need to add a 1 to the whole column of about 52,000. to make it 12012762143, and of course add the 1 to all the numbers in the column individually. Then change all this to a CSV file I can upload . Whew! Is there anyone out there who can help!! Thanks bylsma -- bylsma ------------------------------------------------------------------------ bylsma's Profile: http://www.excelforum.com/member.php...o&userid=31829 View this thread: http://www.excelforum.com/showthread...hreadid=515527 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
phone numbers | New Users to Excel | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |