1 - Used, Like New
2 - Used, Very Good
3 - Used, Good
4 - Used Acceptable
11 - New
I'm sure i could find the answer if i poke around long enough but i thought i could post this here as it would take someone a minute to post the answer v's me spending a hour finding the answer online (and i did try).
Wish I had 4 hands so I could slap you, your mother, your father and give this a thumbs up all at the same time
People on my ignore list:
The Kev Master / kharvel / joer316 /NM 156
If your name is above, don't be expecting a response any time soon.
Here you go. First, use Find/Replace to replace the old values with the new ones. Then, use "Text to columns" with the hyphen as the delimiter to split the data into two columns (so that you have one column of just numbers, then the adjacent columns has the values like "Used, very good"). Then, use the formula I have in column C to output whatever text you want. I trust you can edit the formula yourself, as needed. Right now, I have it output "LN for "Used, Like New", "VG" for "Used, Very Good" etc.
I couldn't make sense of that, but i did find the replace tool in excel and used that. I ended up copying and pasting the info from one column to another and then used the replace tool on that too to change it to what i wanted.
But i do appreciate you taking the time to try and help
I looked closer at the attachment and see what you did. Thanks
It appears i have a new problem. I have a column and some of the numbers had started with a zero which was removed during file transfers. Not all the numbers started with zero, some even start with a B.
Is there a way to add 0's to the front of any line that doesn't have 10 digits? In some cases, it might need 2 0's.
ok i think i found a formula that will work. I just need to copy the info over to an unused column first and then adjust the cell number locations in the formula so i will have the info in the right place.
Slickdeals is able to share the best deals because of the contributions of users like you! If you found a great deal,
please share it with others by posting in our forums.
Welcome to Slickdeals!
Save money here by finding the lowest and cheapest price, best deals and bargains, and hot coupons. We're all about
community driven bargain hunting with thousands of free discounts, promo codes, reviews and price comparisons.
Don't worry, we'll help you find your way. If you haven't already, check out this
that explains the features of our site.