simple cell formating question.
Just kidding i figured it out
Thanks! worked perfectly
"Ewing25" wrote:
sorry im not sure where to put that?
If i put it in a cell it just gives me zero and it rejects it in VBA
"Bob Phillips" wrote:
=--RIGHT(A2,LEN(A2)-Find("-",A2)-2)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Ewing25" wrote in message
...
Ok so i have a column with cells like this:
Persons name - Number
I want to create soemthing that will automatically change it to this:
Number
there are different names and different numbers so im not sure how to go
about it.
Any help would be great
thanks!
|