Do we have a formulae to remove a character? if there is, is there any way we can remove the first 6 digit character on column A and post the 7 up to last character in column C?. I'm trying to look for a better formulae since I will dump huge amount of data in column A and even call out the 7 up to last character in another worksheet.
Greatly appreciate your feedback on this.
Bookmarks