Extract the last number of the string under certain conditions

14spar15 · #1 10-05-2020, 10:03 AM

Hello, I appreciate the response and the work that you put into this. I’m having problems with this though and I don’t know if I’m doing something wrong. Should I be able to add data in column A and in column B right click and refresh? When I do this I get an error that says “Initialization of data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. You see this message again a, create a new data source to correct the database.” I have tried to research this but I can’t figure this out. I am using Excel 2010 if that matters. Thanks

p45cal · #2 10-05-2020, 10:52 AM

Quote:

Originally Posted by 14spar15

Should I be able to add data in column A and in column B right click and refresh?

Yes.

Quote:

Originally Posted by 14spar15

When I do this I get an error that says “Initialization of data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. You see this message again a, create a new data source to correct the database.” I have tried to research this but I can’t figure this out. I am using Excel 2010 if that matters. Thanks

If I'm right that you don't have some version of Power Query (it's an add-in 2010/2013 but built-in in later versions under the Get & Transform section of the Data tab of the ribbon) installed then have a look at these pages:

How To Install Power Query in Excel 2010 | MyExcelOnline
How To Install Power Query in Excel 2010 | MyExcelOnline

Download Microsoft Power Query for Excel from Official Microsoft Download Center
Download Microsoft Power Query for Excel from Official Microsoft Download Center

It seems you either need Excel 2010 Professional Plus with Software Assurance (whatever that is) or to upgrade your Excel. However the following site seems to say that Power Query will work in other versions of Excel albeit not officially supported:

Power Query Version Compatibility and Installation
https://www.myonlinetraininghub.com/...d-installation

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract all characters from the nth number of a string	Marcia	Excel	2	02-24-2020 05:15 PM
Extract States from a String	soldat452002	Excel	9	04-26-2018 04:16 AM
Extract a string from a paragraph	kirkm	Word VBA	7	09-11-2016 06:13 PM
How to extract only numbers from a STRING?	Learner7	Excel	3	07-02-2013 06:25 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM