thegrump179
New Member
- Joined
- Jun 2, 2011
- Messages
- 4
Sorry if I posted this before, but I can not find it.
I have been using two formulas that work well, but if I put them in the same column the latter does not seem to work.
=AND(NOT(ISERR(SEARCH("TP",E1))),F1="")
and
=OR(NOT(ISERR(SEARCH("TP",E3))),F3 <> "")
aim is to highlight a number in column E, that starts with a alphanumeric TP, or LP. ie: TP45678 ( but not CP or PC ) until a number is placed in the corresponding row, column F. That is the first formula shown above and it works well. BUT I would also like it to highlight the number in column E, if the number has a leading zero after the alphanumeric. ie: TP07654. or LP00654, as I need to remove this zero ( additionally it could auto remove the leading zeros ). After cut and pasting thousands of numbers every day from one screen to another the leading zero is hard to pickup. I am using the second formula in column N and it is working well. Regards Ross
I have been using two formulas that work well, but if I put them in the same column the latter does not seem to work.
=AND(NOT(ISERR(SEARCH("TP",E1))),F1="")
and
=OR(NOT(ISERR(SEARCH("TP",E3))),F3 <> "")
aim is to highlight a number in column E, that starts with a alphanumeric TP, or LP. ie: TP45678 ( but not CP or PC ) until a number is placed in the corresponding row, column F. That is the first formula shown above and it works well. BUT I would also like it to highlight the number in column E, if the number has a leading zero after the alphanumeric. ie: TP07654. or LP00654, as I need to remove this zero ( additionally it could auto remove the leading zeros ). After cut and pasting thousands of numbers every day from one screen to another the leading zero is hard to pickup. I am using the second formula in column N and it is working well. Regards Ross
