The "Right" function would probably be useful for this. Ie =right("Cell
reference",10)
Regards,
Adam Wood
"tri_p" wrote:
I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212
so in columns 2 and 4 I would like to strip off the 9 and 1
I do not have alot of programming exp.
thanks for your help
|