I'm scratching my head over this one.
In a cell, I have this text: XXX-XXX
I want to use the FIND function to determine the position of the '-'.
I can do that OK.
The problem I have is, the character I'm looking for will not always be the same.
It will be either a space, a dash (-) or a slash (/).
Can I use the FIND function with multiple criteria to do this?
(Lotus 123 did this very simply with the #OR# function)
Regards,
Andrew.
In a cell, I have this text: XXX-XXX
I want to use the FIND function to determine the position of the '-'.
I can do that OK.
The problem I have is, the character I'm looking for will not always be the same.
It will be either a space, a dash (-) or a slash (/).
Can I use the FIND function with multiple criteria to do this?
(Lotus 123 did this very simply with the #OR# function)
Regards,
Andrew.