Create a cell with only PART of another cells data

[Dave]

I have a column (D) with the following formatted data

0908-1234
0208-0691
0903-0256

I want to create a cell (column) that ONLY contains the last 4 digits
1234
0691
0256


Can some one please tell me how to accomplish this.

Thanks

Dave

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4443 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[Pete_UK]

Try this:

=RIGHT(D1,4)

assuming the data starts on row 1. If you want it as a number, then
you can do this:

=RIGHT(D1,4)*1

Copy down as required.

Hope this helps.

Pete

 

[T. Valko]

One way:

=MID(A1,FIND("-",A1)+1,255)

Note that this returns the string as TEXT (in order to retain the leading
0s.

 

[Dave]

Thanks guys
Petes first answer retained the leading 0 (which I needed)
So it did exactly what I wanted.
Much appreciated

dave

I have a column (D) with the following formatted data

0908-1234
0208-0691
0903-0256

I want to create a cell (column) that ONLY contains the last 4 digits
1234
0691
0256


Can some one please tell me how to accomplish this.

Thanks

Dave
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4443 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4443 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[Pete_UK]

You're welcome, Dave - thanks for feeding back.

Pete