Converts string to another data type. Must ensure successful conversion before use. Returns converted value. Cannot convert strings that don't match data type
SQLizer.io generates CREATE TABLE and INSERT statements from Excel files. Excel2MySQL is the easiest and fastest method without Office installation. DocChow handles multiple Excel spreadsheets and data types
Error occurs when int() cannot parse string as integer. Empty string '' causes ValueError in int(). String representing floating-point values cannot be converted directly
Excel automatically removes leading zeros from numbers. Excel limits numeric values to 15 digits. Numbers can be converted to dates when entered as 01-01
Numbers can be converted to text for search by parts. Different formatting can cause matching issues in VLOOKUP/MATCH. Numbers can be converted for ZIP codes, SSNs, phone numbers
First position in string operations is numbered 1. Noninteger length arguments are rounded to nearest integer. ASCII() returns numeric value of leftmost character. CHAR() converts integers to characters, skipping NULLs. CHAR_LENGTH() returns string length in code points