Perhaps:

C1: =IF(A1=2, LEFT(B1,6) & "6001", B1)

In article ,
"Frank" wrote:

Hi
excel 2003. I have a worksheet with a col (Col B) of GL#'s,
ex: 02-05-4568, 25-46-2004, etc. I want to change ONLY the last 4 digits to
the same #, say 6001. Also, the col next to this one (Col A) has a single
digit in it,. I need to change only the one;s that have a 2 in them?
So col A is single digit1-9. Col B is the GL# like above. All the GL#'s with
a 2 in the preceding row(which is col A) need to be changed.
Boy, I don't think I explained that too well.
I tried. Thanks so much
Frank