I have numbers in Col A and would like to substitute the first character for eg 862490 with number in S1. for e.g if S1 is 2 then after using substitute it should be 262490
I have tried to use , but get an incorrect answer
I have attached sample dataPlease Login or Register to view this content.
Your assistance is most appreciated
Bookmarks