Back to Home

Excel Cheat Sheet

Table of Contents

Overview

Shortcut forumula list for Excel when importing/exporting large amount of data to/from SQL

Formulas

Drivers or Root Causes - Concatonate Cell A, Cell B, Cell C

=CONCATENATE( "(" & A1, ", ", "'" & B1 & "'", C1 & "),")