Aloha
I need a formula/function that identifies part numbers that end in "-H".
IF it ends in "-H" I need it to put HILO in particular column.
THEN
Once it has the HILO location, I need it to EDIT the Part number to Remove the "-H" at the end so that it is the part number without "-H" at the end. This edited part number is to be entered in a particular column.
Using MS Office 365 on WIN 7
Multi column list of part numbers (30,000+)
Please send me help as soon as possible
Tap