I am pretty new to VBA however I am attempting to remove the hyphens and the period from 030-0008-5303.00. All numbers in the Sheet VIP E2:E column are in this format. I need to get them to read 20300008530300. As shown in the code below, I am extracting this data from Sheet1 column Z and pasting it in Sheet VIP column E2:E. Any help would be greatly appreciated. Thank you.
Please Login or Register to view this content.
Bookmarks