May 18 2023 01:36 AM
Hi, I am still in the same problem before.
I already achieved my first problem which is on the left side data.
I retrieve all the data and it is all correct.
By using the formula from Pawn (My fellow friend who help me at first)
Next, I want the right hand side data.
I don't know if my idea is acceptable or not, but I want my right hand side data to be taking the data from the descriptions and excluding the data from the left hand side one.
Can it be done?
Example:
Compatible Sharp Yellow Toner Cartridge (ARRIS) MX2610N MX2615N MX2640N MX3110N MX3115N MX3140N MX3610N MX3640N
LEFT:
Compatible Sharp Yellow Toner Cartridge (ARRIS)
RIGHT:
MX2610N MX2615N MX2640N MX3110N MX3115N MX3140N MX3610N MX3640N
(The formula will be taking the data from the descriptions but exclude the data in LEFT. If there are no data to be extract, it will be >> "" empty.. )
Is it possible? Thank you :)
May 18 2023 02:09 AM
SolutionMay 19 2023 02:45 AM
May 18 2023 02:09 AM
SolutionIn C2:
=RIGHT([@DESCRIPTION],LEN([@DESCRIPTION])-LEN([@LEFT]))