Adding text to a cell based on specific text characters in another cell

Hi, I receive a daily list of around 4k-5k products that up until now is taking me hours to sort.

Attached is a tiny sample of my dilemna. There are 4 columns A and D and 7 rows 2-8.

From the text in range A2:A8 I need to recognise and remove the 'R' at the end of the text in rows 2,4,5,6 - The '-Demo' in row 3,
the '-R' in row 7 and the 'WR' in row 8. and insert the results in the corresponding cells in Column B as shown on the worksheet.

Then i need to have specific text inserted in Column D based on the last 2 characters from the cells in Column C.

The 'C' column range is all 6 digit numbers with 2 letters on the end. These are either 'R4' or 'N1'.

R4 = Refurbished
N1 = New

I have several macros that run within the sheet but I cannot figure this one out, any help would be fantastic

Regards
John

Can be there other letters to be removed rather than R, -Demo, -R and WR??

Hi Johnny, it was my code, not hafizimran's, but it doesn't matter.

What do you mean the columns will be "different"? If you just mean they won't be in columns A and C, it's a simple matter of changing the check range and possibly the offsets.

Oh it wasn't about the credit, I just didn't want you to be confused like "why is one user responding to another user's code?" Anyway:

So the Offsets determine the columns. Offsets are, just in this case, columns to the right of A. So an offset of (0,1) would be 1 column to the right (and zero rows up or down), i.e. column B of the same row. So it's a simple mod, you can see the offset changes. Hopefully this explanation will help if you ever need to adjust the columns.

Please Login or Register  to view this content.

Yeah, i got it after studying what you'd done. Added a Reputation remark, great work and many many thanks, you've made my evening.

Glad to help. Always nice to help someone save a bunch of time.