convert to SQL Format

Excel Function – SQLFormat | To Import Excel to SQL Database

If you want to import excel Table into SQL Database. You are at right place. Most of the time we required to import Excel Data into SQL (Like MySQL Database), and conversion is not easy task. We have prepared Customized fuction for you (called User Defined Function (UDP). This function wraps selected range Row into […]

Continue Reading
Excel function AllConcat

Excel Function – AllConcat | Combine all cells value

You want to combine all cells value scattered in rows and columns. But you dont want to select each cell seperate by comma, then you are at right place. We have designed a function for you which can combine / concat all value by just selecting range inside the function. =AllConcat(A2:D7) Copy above function inside […]

Continue Reading