I need to compare one cell formated like:12345678 to one formated like: 1234-5678 and copy the matched ones. I planned to compare the first four digits of the cell to the first four of the other, and then the last four likewise. I'm having trouble trying to seperate the cell into the first four. I thought it would be something like string1.textleft4 or something like that, I don't know, but it's not working. Any help in the right direction, or a better way, would be greatly appreciated.

Hey Reverand,

Try this... if the number that needs altering is cell B2

=Left(B2, 4) & Right(B2, 4)

If you are then comparing that against a number, it may still be a problem because that may be considered a text string. (Of course it might not:D

If it does, I think the following might work...

=(Left(B2, 4) & Right(B2, 4)) * 1

Hope that helps,

Mike


Mike
EchoVue.com

The second one worked, thank you very much sir.