Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2019, 05:34 PM
EJohnB EJohnB is offline Formula Assistance - Format Change using Formulae Windows 10 Formula Assistance - Format Change using Formulae Office 2019
Novice
Formula Assistance - Format Change using Formulae
 
Join Date: Apr 2019
Location: San Diego
Posts: 4
EJohnB is on a distinguished road
Question Formula Assistance - Format Change using Formulae


I regularly receive a PDF which I can convert to an eXcel document but the format is not one amenable to the tasks I perform next for my golf buddies. I know that the formula experts here can easily solve this dilemma from the attached - the input is in the left 3 columns, the usable (desired) output is in the right 3.
Your help will be really appreciated!
Attached Files
File Type: xlsx Challenge1.xlsx (9.5 KB, 8 views)
Reply With Quote
  #2  
Old 04-16-2019, 11:08 PM
ArviLaanemets ArviLaanemets is offline Formula Assistance - Format Change using Formulae Windows 8 Formula Assistance - Format Change using Formulae Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Does this help?
Attached Files
File Type: xlsx Challenge1.xlsx (10.2 KB, 10 views)
Reply With Quote
  #3  
Old 04-17-2019, 03:33 PM
EJohnB EJohnB is offline Formula Assistance - Format Change using Formulae Windows 10 Formula Assistance - Format Change using Formulae Office 2019
Novice
Formula Assistance - Format Change using Formulae
 
Join Date: Apr 2019
Location: San Diego
Posts: 4
EJohnB is on a distinguished road
Smile This not only helps - it solves my problem!

Thank you very much for your time and effort! Much appreciated.
Reply With Quote
  #4  
Old 07-09-2019, 10:02 AM
EJohnB EJohnB is offline Formula Assistance - Format Change using Formulae Windows 10 Formula Assistance - Format Change using Formulae Office 2019
Novice
Formula Assistance - Format Change using Formulae
 
Join Date: Apr 2019
Location: San Diego
Posts: 4
EJohnB is on a distinguished road
Default Another Similar Challenge, please

I now receive a simple PDF which I convert to eXcel with a number, an <alt>CR, a bullet and a name - I only need the name. A short example is attached with the extraction done manually. A Formula to get everything after the bullet would be a true blessing!
Attached Files
File Type: xlsx Challenge2.xlsx (10.0 KB, 8 views)
Reply With Quote
  #5  
Old 07-09-2019, 10:41 AM
NoSparks NoSparks is offline Formula Assistance - Format Change using Formulae Windows 7 64bit Formula Assistance - Format Change using Formulae Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Look at column H in the file ArviLaanemets supplied for you.
Reply With Quote
  #6  
Old 07-09-2019, 03:30 PM
EJohnB EJohnB is offline Formula Assistance - Format Change using Formulae Windows 10 Formula Assistance - Format Change using Formulae Office 2019
Novice
Formula Assistance - Format Change using Formulae
 
Join Date: Apr 2019
Location: San Diego
Posts: 4
EJohnB is on a distinguished road
Cool Not finding said reply - column H

By Golly, it works - Thanks a bunch!

Last edited by EJohnB; 07-09-2019 at 03:36 PM. Reason: Original Post was WRONG - Way Wrong!
Reply With Quote
Reply

Tags
formula conversion



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Assistance Required mfolland Excel 1 04-16-2019 05:21 PM
Formula Assistance for restricting the number of for analysis gspikesr Excel 3 05-02-2016 11:28 PM
Formula Assistance - Format Change using Formulae Need assistance with multiple IF argument formula Btrrcup610 Excel 1 02-25-2016 11:14 AM
Assistance with Word 2010 If formula ciresuark Word 1 03-09-2015 12:57 PM
Formula Assistance - Format Change using Formulae Formula assistance please blazzercat Excel 2 07-08-2009 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft