Hi I am trying to add text to the start of a forumula without success below
is what I am trying to use. Please help

Joel

=B2&"sold "&,=sum(D820)
--
N/A

=A1&" Sold " &B1& " Bottles of coke."

returns:
Kent Sold 15 Bottles of coke.



"Joel" wrote:

> Hi I am trying to add text to the start of a forumula without success below
> is what I am trying to use. Please help
>
> Joel
>
> =B2&"sold "&,=sum(D820)
> --
> N/A

Just get rid of the ",=" before SUM.

=B2 & " sold " & SUM(D820)

The spaces I've added aren't strictly necessary, but makes it easier to
read.

--
Ian
--
"Joel" <(E-Mail Removed)> wrote in message
news:4AAD0040-4A16-4228-BD1A-(E-Mail Removed)...
> Hi I am trying to add text to the start of a forumula without success
> below
> is what I am trying to use. Please help
>
> Joel
>
> =B2&"sold "&,=sum(D820)
> --
> N/A

hi
close
=B2&" "&"sold"&" "&Sum(D820)
the exta " " are for spaces between the words and numbers.
worked in xp on tuesday.

regards
FSt1

"Joel" wrote:

> Hi I am trying to add text to the start of a forumula without success below
> is what I am trying to use. Please help
>
> Joel
>
> =B2&"sold "&,=sum(D820)
> --
> N/A

> =B2&" "&"sold"&" "&Sum(D820)
> the exta " " are for spaces between the words and numbers.
> worked in xp on tuesday.

A tidier way is to put the spaces either side of the "sold" string (ie "
sold "). it gets rid of 2 amperands and 4 double-quotes.

=B2&" sold "&Sum(D820)

--
Ian
--

Hi thanks for all your help I tried them all and all I get is a blank cell
with a £ sign in it more help would be appreciated

Joel
--
N/A


"IanC" wrote:

> Just get rid of the ",=" before SUM.
>
> =B2 & " sold " & SUM(D820)
>
> The spaces I've added aren't strictly necessary, but makes it easier to
> read.
>
> --
> Ian
> --
> "Joel" <(E-Mail Removed)> wrote in message
> news:4AAD0040-4A16-4228-BD1A-(E-Mail Removed)...
> > Hi I am trying to add text to the start of a forumula without success
> > below
> > is what I am trying to use. Please help
> >
> > Joel
> >
> > =B2&"sold "&,=sum(D820)
> > --
> > N/A
>
>
>

hi
you're right but i wanted them to show. which is why i pointed them out.
also give a better understanding of how it all works. sometimes the hard way
teaches more.

regards
FSt1

"IanC" wrote:

> > =B2&" "&"sold"&" "&Sum(D820)
> > the exta " " are for spaces between the words and numbers.
> > worked in xp on tuesday.
>
> A tidier way is to put the spaces either side of the "sold" string (ie "
> sold "). it gets rid of 2 amperands and 4 double-quotes.
>
> =B2&" sold "&Sum(D820)
>
> --
> Ian
> --
>
>
>

Hi Joel

What do you have in B2 and in D820?
In a spare cell, type =B2. Do you get what B2 contains?
Try the same thing with =SUM(D820). Is this correct?
Where does the £ sign come from? That's not in your formula, so I'm assuming
you've formatted as currency. If so, it shouldn't show the £ sign unless
there's something after it.

--
Ian
--
"Joel" <(E-Mail Removed)> wrote in message
news:287CAEF5-2763-4064-A070-(E-Mail Removed)...
> Hi thanks for all your help I tried them all and all I get is a blank cell
> with a £ sign in it more help would be appreciated
>
> Joel
> --
> N/A
>
>
> "IanC" wrote:
>
>> Just get rid of the ",=" before SUM.
>>
>> =B2 & " sold " & SUM(D820)
>>
>> The spaces I've added aren't strictly necessary, but makes it easier to
>> read.
>>
>> --
>> Ian
>> --
>> "Joel" <(E-Mail Removed)> wrote in message
>> news:4AAD0040-4A16-4228-BD1A-(E-Mail Removed)...
>> > Hi I am trying to add text to the start of a forumula without success
>> > below
>> > is what I am trying to use. Please help
>> >
>> > Joel
>> >
>> > =B2&"sold "&,=sum(D820)
>> > --
>> > N/A
>>
>>
>>