In column A I have numbers in different formats. Some 6 digits alpha
numeric, some are 6 digits followed by 3 digits and separated with a dash
(6-3). Another group is similar: 2 digits - 5 digits - 2 digits (2-5-2). In
column B I'd like to insert a function (e.g. IF statement) that would respond
(yes, etc) when the adjacent cell in column A contained a 2-5-2 number. Does
anyone have a idea of how to do this? Thanks.