Spreadsheets Excel....... - Microsoft Community

have column of uk numbers  02,01,03,08 etc...... need remove 0 @ start of number , replace 0044 can explaining process in layman's terms please.

hi tyna,

assuming data in column , first data point in a1, can use following formula:

=if(or(left(a1,1)=0,left(a1,1)="0"),"0044"&right(a1,len(a1)-1),a1)

if put next data , change a1 references equivalent first data point in column, can copy or fill-handle-drag formula down perform calculation on each of cells.

please let me know if answers question marking answer , if need further assistance.

thanks,
ebw

Office / Excel / Windows 10 / Unknown/other