Thread: phone numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
bylsma
 
Posts: n/a
Default phone numbers


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