How in Excel Command

[SmithToronto]

Hi,

I have following Excel data. How I can get the desired result in D2,D3 and D4 columns. If any column has NULL or blank then values should be '' in Insert command, as mentioned in the D columns

A1   B1     C1        D1

1      E       AAA    Insert into TPG (A1, B1, C1) values ((Select max(A1)+1 from DIC),'E','AAA')

2      E        BBB     Insert into TPG (A1, B1, C1) values ((Select max(A1)+2 from DIC),'E','AAA')

3                           Insert into TPG (A1, B1, C1) values ((Select max(A1)+3 from DIC),'','')

[#2]

Hi

Sorry but could you try explaining what you need in another way, as I'm struggling to understand what you want to achieve. uploading a demo Excel file or Excel screenshots can also help us help you.

Thanks

Wyn
MVP
UTC+8