Hi guys. I've been wrestling with this problem for a while & cannot find the solution. Here goes the example of my problem:
round_green_34"_small
triangle_sea_blue_55"
square_red_45"_big
octagon_50"_small
I want to separate above text into several columns so the result will be like attachment. I still cannot find the right function & formula. I would really appreciate if anyone can find the solution. Thank you in advance.
Last edited by izzue; 03-19-2015 at 10:26 AM. Reason: indenting
hello,
have a look at attached file.
Hope it helps
Book1.xlsx
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thanks Miroslav, really appreciate it. Actually the list gets more complicated & I cannot find the right function to solve this problem. The list goes like this:
round_light_red_20"
triangle_dark_green_45"_medium
square_alpha3_light_blue_50"
pentagon_beta_purple_45"_small
hexagon_alpha7_dark_blue_30"_large
octagon_sigma_light_brown
Anybody can help me solve this text string so they can be divided into separate columns like below:
excel_test.JPG
Really appreciate if anyone can help find the right function.
How many descriptive terms (light, dark) can be applied to the colours? Are there just the two? If more - what are they?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Only 1 descriptive term for the color, e.g light, dark (different length of text). Either 1 descriptive term or none. Tq
Still not there yet. The problem is the "missing term". I can't immediately see how to get the columns lined up correctly when the greek character isn't there...
There's a guy here - Alkey - who's really good with these SUBSTITUTE functions. Maybe he can finish the job...
Last edited by Glenn Kennedy; 03-21-2015 at 04:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks