How can I replace multiple data in excel ?
=(16&RIGHT(A1,2))*1
Vaya con Dios,
Chuck, CABGx3
"Nanou" wrote:
Hi there,
I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
...meaning I should have 1601.......1620.
Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!
Thx.
|