Creating a formula that will return a text result if it finds part of that phrase

**mhump3** · 03-12-2013, 05:33 AM

Hi All,

Thanks in advance for your help! I've been looking around and can only "almost" find an answer to this.

I have a Column that contains Analytics data and I want to put another table next to it to simplify that data:

"google / cpc" = PPC
"google / direct" = Direct
"google / organic" = Organic

These bits I can sort, however the final section is wild:

"[name of referrer] / referral" = Referral

I'm just looking for one, nice, clean column that will look at the first column and see the relevant part of text and deliver the short response.

cheers,

Myles

**:) Sixthsense :)** · 03-12-2013, 05:35 AM

Can you please explain how you arrive this one

"google / cpc" = PPC

**mhump3** · 03-12-2013, 05:48 AM

Sure - In one column it currently says google / cpc and I want to create a column next to it where it will just say PPC

Hope that makes sense?

**abubaniyan** · 03-12-2013, 05:56 AM

hi,
i don't know what u want exactly but may be this can help.....!

=MID(a1,FIND("/",a1,1)+1,LEN(a1)-FIND("/",a1,1))

**:) Sixthsense :)** · 03-12-2013, 06:37 AM

Still not clear how you are getting PPC

"google / cpc" = PPC

Creating a formula that will return a text result if it finds part of that phrase

LinkBack

Thread Tools

Rate This Thread

Display

Creating a formula that will return a text result if it finds part of that phrase

Re: Creating a formula that will return a text result if it finds part of that phrase

Re: Creating a formula that will return a text result if it finds part of that phrase

Re: Creating a formula that will return a text result if it finds part of that phrase

Re: Creating a formula that will return a text result if it finds part of that phrase

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions