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, 6 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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Does this help?
Attached Files
File Type: xlsx Challenge1.xlsx (10.2 KB, 8 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, 6 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: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
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

Thread Tools
Display Modes


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 12:22 PM.


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