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

Closed

a - Updated on Mar 2, 2018 at 04:29 PM
Blocked Profile - 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

Insert the number 001 in column A if B A00-A10
How to insert a checkmark in word - Guide
How to insert photo in word for resume - Guide
Insert draft watermark in word on all pages - Guide
How to insert @ in a laptop - Guide
Insert gif in excel - Guide

1 response

Answer 1 / 1

Blocked Profile
Mar 2, 2018 at 02:52 PM

This is really confusing, because you have a reference of:

B A00-A10

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

Similar discussions

Nfs most wanted 2005 shows "please insert the correct CD

Micro sd card showing "please insert Disk"

If cell A1 has text then cell B2 has today's Date

Similar discussions

Subscribe To Our Newsletter!