Hi,
I have one worksheet in which there are two columns. In one column there are blank cells and some cells has numbers which start from 1xxxx, 2xxxx, 3xxxx, 4xxxx, 5xxxx & 6xxxx numbers.
I want to add beside this column, if it is blank cell then it should be "OH" and if the number in cells start from 1xxxx, then PM01, 2xxxx, = PM02, 3xxxx, = PM03, 4xxxx, = PM04, 5xxxx, = PM05 and 6xxxx, = PM06.
Appreciate for your help. Thanks
Manzoor