Andreas Hermle
asked on
Extract strings / characters from the right till the first occurrence of a comma, using an excel formula
Dear Experts:
I would like to extract strings from the right till the first occurrence of a comma, using an Excel formula.
Example
A1 B1 (formula)
Scissors, bipolar, 23 cm 23 cm
Laser, medical, 234 kg 234 kg
Plate, regular, 87 holes 87 holes
Could somebody help me with this probably nested formula.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I would like to extract strings from the right till the first occurrence of a comma, using an Excel formula.
Example
A1 B1 (formula)
Scissors, bipolar, 23 cm 23 cm
Laser, medical, 234 kg 234 kg
Plate, regular, 87 holes 87 holes
Could somebody help me with this probably nested formula.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Really, a great job from all of you. I really appreciate it. Regards, Andreas
ASKER
If the length of the formula is a criterion, Ryan Chong's formula is the best one.
Rob Henson's formula is also very concise but I just had cases in which just one comma was present.
I will distribute the points accordingly. Again, thank you very much for your superb and professional help. I really appreciate it. Regards, Andreas