Insert the number 001 in column A if B A00-A10

a - Mar 2, 2018 at 10:47 AM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Mar 2, 2018 at 02:52 PM
Hello,

In column B the data range from A00-Z99
and I want to insert the number 001 in column A if B A00-A10 and 002 if columnB A11-A20

which function can I use to complete this task
thank you very much


See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 2, 2018 at 02:52 PM
0
Thank you
This is really confusing, because you have a reference of:
B A00-A10


Is that a value of A00 in Cell B1, or what?
Respond to ac3mark