Link to home
Start Free TrialLog in
Avatar of Patricia Timm
Patricia TimmFlag for United States of America

asked on

leading apostrophies in excel column

why am I getting leading apostrophies in my columns even after I delete them? will that affect my export into the database
SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am curious how the apostrophes are still there if you removed them?  How did you remove them?  Find/Replace?
I believe if you convert the data to a table it will eliminate the apostrophes and still keep the data as text.
Avatar of Patricia Timm

ASKER

Some of the column data are numbers. They are importing them into mysql and I am not sure how the constraints on the database tables are set up. If the excel file passed to us is defining the number columns as text (string) and I am importing them into the database as text (string) ... will this affect the use of these numbers as calculations? If some of the columns in excel are defined as text but are numbers can they still manipulate them for calculations in the database? Thanks in advance
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks - solution is the power query approach. I appreciate both of your assistance to resolve.
Avatar of Bill Prew
Bill Prew

Welcome.


»bp
Thanks Patricia..