You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson