I have a simple spreadsheet with UPCs along with other information. I need to remove the first 2 digits from each UPC entry as they are too long. I am trying to use the =RIGHT formula to just grab the whole text string minus the two beginning numbers. What I'm getting is my formula in a cell with no result, as seen in the example below. If I click on my formula, in C2, it looks like this: =RIGHT(B2,LEN(B2)-2). In my experience this means the formula isn't written correctly but I've googled multiple times and I feel I'm entering it correctly. I'm hoping someone here can steer me into what I need to be doing.
My UPCs are entered as text, as if they get switched to numbers Excel removes ALL the preceding 0s and some of them are necessary. Tried using text to column and that's what happened. Coverted to numbers and I lost some essential 0s.
WHAT I GET:
14.97 00883929131716 =RIGHT(B2,LEN(B2)-2) 29.98 00883929024292 9.99 00097360301243
WHAT I WANT:
14.97 00883929131716 883929131716 29.98 00883929024292 9.99 00097360301243
Bookmarks