Is there any way to add a prefix into a query in excel?
I want the output to add a ' to the start of all numerical fields because when i import into a foxpro database later on this is needed for the application which will run it.
Normally i just add them all in notepad but i have about 15k rows in this spreadsheet.
I want the output to add a ' to the start of all numerical fields because when i import into a foxpro database later on this is needed for the application which will run it.
Normally i just add them all in notepad but i have about 15k rows in this spreadsheet.