Excel - Text (String) data type

Search

=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

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

Lpad

=TEXT(1,"00")

01

Concat

See Excel - Concatenate function to create SQL