Hello,
I am trying to number and rename data. I cannot use the replace function because the spreadsheet is extremely large.
Data in column A occupies a different length (for example 001ifpim occupies 4 rows but 002ifpim only 1). I need to rename all the 001ifpim as 001; all the 002ifpim as 002.
The attached screenshot should make clear what I am trying to do.
Is there a formula to do this?
Thank you!
Screen Shot 2017-05-26 at 2.28.48 PM.png
Bookmarks