A lot many time, I have seen SQL coders struggling to get the equivalent function on excel. Therefore this series is dedicated to some of the common SQL functions and their excel counterparts. This post deals with the String Functions and there will be post that will follow up with other functions too.
String Functions in Sql and their Excel Equivalents
|Function in SQL||Function in Excel|
To get the Excel Equivalent of SQL Date Functions click here.
To get the Excel Equivalent of SQL Math Functions click here.
To get the Excel Equivalent of SQL Analytical Functions click here.
If you happen to find out the equivalent Excel functions of any other SQL string functions please mention the same in the comment below.