simple cell formating question.
 

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!

simple cell formating question.
 

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

simple cell formating question.
 

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!

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!