SOLVED

Asking for another way.

Brass Contributor

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 :)

2 Replies
best response confirmed by syazaaoa95 (Brass Contributor)
Solution

@syazaaoa95 

In C2:

=RIGHT([@DESCRIPTION],LEN([@DESCRIPTION])-LEN([@LEFT]))

Hey Hans,

thank you for your suggestion. It does help me to get only the right data only!

Thanksss
1 best response

Accepted Solutions
best response confirmed by syazaaoa95 (Brass Contributor)
Solution

@syazaaoa95 

In C2:

=RIGHT([@DESCRIPTION],LEN([@DESCRIPTION])-LEN([@LEFT]))

View solution in original post