use =char(13) to get the CR in.

"PSULionRP" wrote:

I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a
CONCATENATE Statement, see below. My one problem is getting the "/" into my
Oracle statements to separate them so that it will properly process the
multiple UPDATE statements.

Can someone help me with this formula??? I'm not sure how to carriage retun
so that the "/" appears in the first column. This is where Oracle wants it
when I copy and paste my values into a SQL Script.

Any help is GREATLY appreciated and Thanks in advance for your review and
hopeful for a reply.

PSULionRP

=CONCATENATE("UPDATE TableName SET ColumnName = ", "'", TRIM(E2), "'", "
WHERE KeyColumn = ", B2,
" /")