03-22-2007, 12:28 PM
|
|
Registered User
|
|
Join Date: 22 Mar 2007
Location: Atlanta,Georgia
Posts: 2
|
|
|
I am Still not clear
Quote:
|
Originally Posted by oldchippy
Try something like this in B1,
="1"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","") then drag down column B
|
If my numbers are in colum... A
How and where do I start?
|