Hi,
I already concatenate cell and put single quote, my problem is i have NULL value and I like to have a condition that all cell that have NULL value will not have a single quote.
Example
A B C
1 Francis Lee NULL
2 Lee Young 12345
My Formula:
=CONCATENATE("('", A1, "', '", B1, "', '", C1, "')")
Output:
('Francis', 'Lee', 'NULL')
My Desired Output:
('Francis', 'Lee', NULL)
Thank you, badly need this.
Bookmarks