simple cell formating question.

[Ewing25]

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!

 

[Bob Phillips]

=--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]

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

 

[Ewing25]

Just kidding i figured it out

Thanks! worked perfectly