Extract each substring from current cell

**6StringJazzer** · 02-15-2010, 12:48 PM

Here are two solutions. The first requires "helper" cells. It's more efficient but if you don't care for that you can construct "megaformulas" as shown in the second solution.

**clickcoder** · 02-16-2010, 03:22 AM

Originally Posted by 6StringJazzer

Here are two solutions. The first requires "helper" cells. It's more efficient but if you don't care for that you can construct "megaformulas" as shown in the second solution.

Dear 6StringJazzer,

Complex one is good for me

But when I look your example it couldn't found 3rd (Yho)

Thanks for all friends for their suggestions