Forum Discussion
alidagreatest
Dec 07, 2021Copper Contributor
Excel cost us few thousands dollar for changing SKUs to dates
Hi, I work at a company where I import large excel sheet containing our product info to our website. It often happens that SKUs are similar to data, sometimes even a number like this 3-3231 is t...
alidagreatest
Dec 08, 2021Copper Contributor
Sorry if I am not clear or overly descriptive. This is how I do it: Take the following in a excel sheet and try removing prefixes such as NB- and see what happens:
Even after you turn them to text and run formula like find and replace with empty string, it turns them to number and then dates.
NB-3-3286
NB-3-3286/01
NB-3-3286/034
NB-3-3286/03N
NB-3-3286/04
NB-3-3286/06
NB-3-3286/07