Text Function SyntaxThe LEFT FunctionThe RIGHT FunctionThe MID FunctionThe TRIM FunctionThe LEN FunctionThe FIND and SEARCH FunctionsThe REPT FunctionThe CONCATENATE and & FunctionsThe REPLACE FunctionThe VALUE FunctionThe UPPER and LOWER FunctionsThe CHAR FunctionAnswers to This Chapter’s QuestionsExtracting Data by Using the Text To Columns WizardProblems