Beth

Without trying to scope out your formulas..............

You can enter a hard return in a formula by using the CHAR(10) function.

=A1 & CHAR(10) & B1 & CHAR(10) & C1 will place two hard returns in the cell.

="this is one line" & CHAR(10) & "this is the next line"


Gord


On Thu, 15 Feb 2007 11:18:10 -0800, BethB
wrote:

I know it is a formula, I am asking if it is not recognizing a hard return
because it is a formula.
I cannot figure out how to insert a hard return into a formula.

Here is what is in the cell I am having a problem with

=K8 & " " & L8 - not too complicated so far....

Here is where it gets complicated

This is in cell K8

="^If GEMUS Mailbox = "&""""&A8&""""&" Then If no "&B8&" Work Task exists,
Create a new "&""""&B8&""""&" Work Task with a "&""""&C8&""""&"
Classification and set Status = "&""""&I8&""""&" and Department = " & """" &
H8 & """" & ". Else If a "&B8&" Work Task already exists, and there is no
S2IQC Work Task OR a "&B8&" Work task already exists where the Rework Flag =
"&""""&"Yes"&""""&", Do not create a new Work Task and for the newest "&B8&"
Work Task set Status = "&""""&I8 &""""&". Else If a "&B8&" Work Task already
exists and there is an existing S2IQC Work Task, Create a new
"&""""&B8&""""&" Work Task with a "&""""&C8&""""&" Classification and set
Status = "&""""&I8&""""&" and Rework Flag = "&""""&"Yes"&""""&". If the
"&B8&" Work Task existed and was suspended, close that supend record by
setting the Suspend End Date to Today. "

This is in L7

= "If an Analyze/maintain Oscar Benefits or Optimum Flow Work Task exists,
set their status to "&""""&"Closed"&""""&" See TQR rules for existing I2OQC
Work Tasks. For the newest Code GEMUS Work Task, set Status = " & """" & J8 &
"""" & ". Create a new Suspend record for the newest Code GEMUS Work Task
setting Suspend Start = Today, Suspend Location = " & """" & D432 & """" & ",
Suspend Reason = " & """" & E432 & """" & " Carve Out MTM Flag = " & """" &
F432 & """" & " and Carve Out Performance Flag = " & """" & G432 & """" & "
If the Code GEMUS Work Task was already suspended, close that supend record
by setting the Suspend End Date to Today.~"


As you can see it is rather long

This the text that should show:

^If GEMUS Mailbox = "CBA.1" Then If no Analyze/Maintain Oscar Benefits Work
Task exists, Create a new "Analyze/Maintain Oscar Benefits" Work Task with a
"Group Update (GEMUS)" Classification and set Status = "In-Process" and
Department = "Benefit Coding". Else If a Analyze/Maintain Oscar Benefits Work
Task already exists, and there is no S2IQC Work Task OR a Analyze/Maintain
Oscar Benefits Work task already exists where the Rework Flag = "Yes", Do not
create a new Work Task and for the newest Analyze/Maintain Oscar Benefits
Work Task set Status = "In-Process". Else If a Analyze/Maintain Oscar
Benefits Work Task already exists and there is an existing S2IQC Work Task,
Create a new "Analyze/Maintain Oscar Benefits" Work Task with a "Group Update
(GEMUS)" Classification and set Status = "In-Process" and Rework Flag =
"Yes". If the Analyze/Maintain Oscar Benefits Work Task existed and was
suspended, close that supend record by setting the Suspend End Date to Today.
If an Analyze/maintain Oscar Benefits or Optimum Flow Work Task exists, set
their status to "Closed" See TQR rules for existing I2OQC Work Tasks. For the
newest Code GEMUS Work Task, set Status = "Suspended". Create a new Suspend
record for the newest Code GEMUS Work Task setting Suspend Start = Today,
Suspend Location = "External", Suspend Reason = "WPAQC.AGENT11" Carve Out
MTM Flag = "No" and Carve Out Performance Flag = "Yes" If the Code GEMUS Work
Task was already suspended, close that supend record by setting the Suspend
End Date to Today.~


This is what shows

^If GEMUS Mailbox = "CBA.1" Then If no Analyze/Maintain Oscar Benefits Work
Task exists, Create a new "Analyze/Maintain Oscar Benefits" Work Task with a
"Group Update (GEMUS)" Classification and set Status = "In-Process" and
Department = "Benefit Coding". Else If a Analyze/Maintain Oscar Benefits Work
Task already exists, and there is no S2IQC Work Task OR a Analyze/Maintain
Oscar Benefits Work task already exists where the Rework Flag = "Yes", Do not
create a new Work Task and for the newest Analyze/Maintain Oscar Benefits
Work Task set Status = "In-Process". Else If a Analyze/Maintain Oscar
Benefits Work Task already exists and there is an existing S2IQC Work Task,
Create a new "Analyze/Maintain Oscar Benefits" Work Task with a "Group Update
(GEMUS)" Classification and set Status = "In-Process" and Rework Flag =
"Yes". If the Analyze/Maintain Oscar Benefits Work Task existed and was
suspended, close that supend record by setting the Suspend End Date to Today.
If an Analyze/maintain Oscar Benefits or Optimum Flow Work Task exists, set
their status to "Closed" See TQR rules for existing I2OQC Work Tasks. For the
newest Code GEMUS Work Task, set S

Once again - any help is appreciated

Beth