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

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

Perhaps:

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

Another possibility is...

C1: =IF(A1=2,REPLACE(B1,7,4,"6001"))

Rick

Sorry, I know I didn't explain correctly.Colums are full from A-G. I don't
understand where to put the function . I will have to read a some more. I
also do not understand what the numbers 6, and 7&4 have to do with this? Ok
I need to read a lot, lot more!
Thanks
Frank

"Rick Rothstein (MVP - VB)" wrote in
message ...
Perhaps:

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

Another possibility is...

C1: =IF(A1=2,REPLACE(B1,7,4,"6001"))

Rick

If you are struggling to understand the syntax of an Excel function, type
its name into Excel's help facility. Every function [except DATEDIF()] has
an explanation, and usually examples, and pointers to related functions.
--
David Biddulph

"Frank" wrote in message
...
Sorry, I know I didn't explain correctly.Colums are full from A-G. I don't
understand where to put the function . I will have to read a some more. I
also do not understand what the numbers 6, and 7&4 have to do with this?
Ok I need to read a lot, lot more!
Thanks
Frank

"Rick Rothstein (MVP - VB)" wrote in
message ...
Perhaps:

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

Another possibility is...

C1: =IF(A1=2,REPLACE(B1,7,4,"6001"))

Rick

In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote:

Every function [except DATEDIF()] has an explanation, and usually
examples, and pointers to related functions.

And MacXL and WinXL00 include the DATEDIF() explanation.

I appreciate all the comments. I have much to learn. But in this case, I am
having a hard time understanding what the 7&4 are about in this function?
=IF(A1=2,REPLACE(B1,7,4,"6001"))
and what the 6 is about in this one? =IF(A1=2,REPLACE(B1,7,4,"6001"))
Thanks
Frank

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If you are struggling to understand the syntax of an Excel function, type
its name into Excel's help facility. Every function [except DATEDIF()]
has an explanation, and usually examples, and pointers to related
functions.
--
David Biddulph

"Frank" wrote in message
...
Sorry, I know I didn't explain correctly.Colums are full from A-G. I
don't understand where to put the function . I will have to read a some
more. I also do not understand what the numbers 6, and 7&4 have to do
with this? Ok I need to read a lot, lot more!
Thanks
Frank

"Rick Rothstein (MVP - VB)" wrote in
message ...
Perhaps:

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

Another possibility is...

C1: =IF(A1=2,REPLACE(B1,7,4,"6001"))

Rick