Hi all,
I have the following set of characters in a cell
CCC01/23333
and I wish to drag the cell down so only the first set of numbers change as below, however, when I drag the cell down the last set of numbers change.
Does anybody know how I can fix this?
CCC01/23333
CCC02/23333
CCC03/23333
CCC04/23333
CCC05/23333
CCC06/23333
I have the following set of characters in a cell
CCC01/23333
and I wish to drag the cell down so only the first set of numbers change as below, however, when I drag the cell down the last set of numbers change.
Does anybody know how I can fix this?
CCC01/23333
CCC02/23333
CCC03/23333
CCC04/23333
CCC05/23333
CCC06/23333