Create a cell with only PART of another cells data

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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
 
One way:

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

Note that this returns the string as TEXT (in order to retain the leading
0s.
 
Thanks guys
Petes first answer retained the leading 0 (which I needed)
So it did exactly what I wanted.
Much appreciated

dave

Dave said:
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
Click to expand...

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

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
Back
Top