|
#31 | |||
Fan Forum Legend
Joined: May 2017
Posts: 559,865
|
Let Me Go the Right Way - The Supremes.
|
|||
|
#32 | |||
Fan Forum Legend
|
Master of Puppets - Metallica
|
|||
|
#33 | |||
Fan Forum Legend
|
Near You Always - Jewel
__________________
"Our lives shouldn't be measured by how much money we make or by how well known we are, but by how much fulfillment we can find in our everyday existence." ~ Ewan McGregor
|
|||
|
#34 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
O Love That Will Not Let Me Go - David Phelps
__________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
|
#35 | |||
Fan Forum Legend
|
Power Up - Red Velvet
|
|||
|
#36 | |||
Supreme Fan
Joined: Apr 2020
Posts: 9,369
|
Questions of My Childhood -- Kansas
__________________
"Earth is the cradle of humanity. But one cannot live in a cradle forever." -- Konstatin Tsiokovsky
|
|||
|
#37 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
MM!!!
It's a mad house here. My colleague can't work since this morning, nothing but phone calls. You have your new device by now? Radio Nowhere - Bruce Springsteen __________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
|
#38 | |||
Supreme Fan
Joined: Apr 2020
Posts: 9,369
|
Good morning. No, it'll probably be next week. Right now I'm trying to come up with an Excel formula that will find a number within a mixed text string and extract the number.
Safety Dance -- Men Without Hats __________________
"Earth is the cradle of humanity. But one cannot live in a cradle forever." -- Konstatin Tsiokovsky
|
|||
|
#39 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
You can do a list of nested IF(IFERROR(FIND(...);0)>0;LEFT/RIGHT/...). Doesn't look good in your formula (becomes really complex) but it works.
Ta Karavia Mou Kaio - Nikos Portokaloglou (I Burn My Ships) __________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
|
#40 | |||
Supreme Fan
Joined: Apr 2020
Posts: 9,369
|
I've got a field that looks like A1B2XYZ-160. I need the 160 part. I came up with:
MID(B2,(SEARCH("-",B2)+1),3) Used Cars -- Bruce Springsteen __________________
"Earth is the cradle of humanity. But one cannot live in a cradle forever." -- Konstatin Tsiokovsky
|
|||
|
#41 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
Ok, but you already knew it was at the end and after a dash. I assumed you'd need to know the begin and end position by searching for a digit.
Vallende Sterren - Nick En Simon (Falling Stars) __________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
|
#42 | |||
Supreme Fan
Joined: Apr 2020
Posts: 9,369
|
I thought about that, but the portion of the string before that has digits in it that I don't want.
Waffle House -- Snails & Botnek __________________
"Earth is the cradle of humanity. But one cannot live in a cradle forever." -- Konstatin Tsiokovsky
|
|||
|
#43 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
Xanarthe I Ora - Giannis Giokarinis (The Time Has Come Again)
__________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
|
#44 | |||
Supreme Fan
Joined: Apr 2020
Posts: 9,369
|
Your Biggest Mistake -- Ellie Goulding
__________________
"Earth is the cradle of humanity. But one cannot live in a cradle forever." -- Konstatin Tsiokovsky
|
|||
|
#45 | |||
Ultimate Fan
Joined: Apr 2020
Posts: 8,809
|
Ze Kan Hem Niet Vergeten - Yasmine (She Cannot Forget Him)
__________________
A smile is a curve that sets everything straight
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am beautiful no matter what they say |
|||
Bookmarks |
Tags |
abc , game , music |
Forum Affiliates | |
Thread Tools | |
|