Excel - Text (String) data type

Card Puncher Data Processing


=IF(ISERROR(FIND("Value to search","In this little text")),"Not Found","Found")

If the find function doesn't find the text it will return a #value. To avoid this the ISERROR function is used.


=SUBSTITUTE("The text where I want to substitute something","The text to search", "The text that will replace the text to search")




See Excel - Concatenate function to create SQL

Discover More
Card Puncher Data Processing
Excel - Character

in Excel See also: How to create an alphabet in 26 cells: In the ref cell, enter A1:A26 In the function cell, enter =CHAR(64+ROW()) Ctrl+Enter to copy the formula to the selection
Card Puncher Data Processing
Excel - Datatype

This article is a generic article which talk the Excel datatype. The following table shows how Microsoft Excel driver data types are mapped to ODBC SQL data types. The Microsoft Excel driver assigns...

Share this page:
Follow us:
Task Runner