Remove the First Text with formula

[webmax]

Hi

Kindly find the attached file and it contains alpha and numeric values. I want to remove the first letter "S" in the with the help formula. I try to put the Find and Replace using Ctrl+H the Digit which having zero is not coming for example if the Number S00760. if i find and replace it is showing as 760 i want to come as 00760.

Please Help

 

[NARAYANK991]

Hi Shahul ,

Try this :

=MID(A2,2,255)

Copy this down.

Narayan

 

[webmax]

thanks sir it is working