Split Text into 1 Column from String

[shaon814]

Hi guys,

I'm trying to extract the first and last name from the string below into a Cell.

[TABLE="width: 428"]
<tbody>[TR]
[TD]https://websitename.com/tour#/first-last?p=237[/TD]
[/TR]
</tbody>[/TABLE]

I tried the following function "=RIGHT(C2,LEN(C2)-SEARCH("bands/",C2,1)-5)", but only getting "first-last?p=237".

Is there a way to get only the First and Last name in the cell and not all the other characters?

-Thanks in advance!

 

[shaon814]

Just tried it - no luck =/

the format is

https://website.com/type/first-last?p=237

If you single example is truly representative of what your actual data could look like, then this formula will work...

=SUBSTITUTE(MID(LEFT(A1,FIND("?",A1)-1),FIND("#/",A1)+2,99),"-"," ")

 

[Rick Rothstein]

Just tried it - no luck =/

the format is

https://website.com/type/first-last?p=237

Okay, your one single example was not representative. Give this formula a try then...

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("?",A1)-1),"/",REPT(" ",300)),300)),"-"," ")

 

[shaon814]

Okay, your one single example was not representative. Give this formula a try then...

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("?",A1)-1),"/",REPT(" ",300)),300)),"-"," ")

That worked - thank you!!!