Hi,
I have data as shown in column A in the attached workbook.
In column C I would like to create a formula that will assess the contents of the adjacent cell in column A and respond accordingly:
If the data in column A is text, simply return the text string ("AAA" in my example)
If the data in column A is a number and less than 10, return the number as text with a zero in front ("08" in my example)
If the data in column A is a number and 10 or more, return the number as text ("12" in my example)
Can someone please suggest a formula that will achieve this?
Thanks!
Bookmarks