conversions

Hey everyone, I hope you are able to help! I am using Excel 2016 + Windows 10. I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the...

Hello, I am currently trying to devise a way (using excel and vba), that whenever a number is entered followed by a string of text typically a imperial measurement abbreviation ("in", "ft", "Yrd"), The number is converted to a metric equivalent and the abbreviation is deleted. Here is a...

I have seen a few posts similar to what I am looking to do, but nothing that seems to hit this question directly. My apologies if I am wrong. This is something I have found a few rough patches for in the past, but am looking to do in one straightforward formula (if possible) since I need to...

I've been tasked with trying to convert Quattro Pro and Lotus 1-2-3 files into XLS format so we can use the past historical data for a new research project. The file extensions include: WQ1, WR1, WB2, and WB3. I downloaded OpenOffice and Corel WordPerfect Office Suite in an attempt to open the...

Hello. This is a bit off topic of Excel other than I'm using the program, but I'm presuming a lot of people on here are in marketing and do similar things so looking for some advice. If anyone knows of a marketing / data forum where this stuff is commonly discussed please let me know as I could...