Solved Want to see cost per click in Google campaign

May 10, 2013 at 21:01:49
Specs: Windows 7
Excel 2010, I have a description field that says Campaign activity: X (XX) clicks. - How do I copy the number after :_ and copy that into another number field?

See More: Want to see cost per click in Google campaign

Report •

#1
May 11, 2013 at 00:44:47
✔ Best Answer
If by "number" you mean X (XX), try this:

With Campaign activity: X (XX) clicks in A1, use:

=MID(A1,FIND(":",A1)+2,FIND(")",A1)-FIND(":",A1)-1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question