How do embbed a cell within a sentence
 

For example if I have information in cell A1 but my sentece is in A4. I want
the information to show up in the middle of the sentece.

A1 = 5

she ate xx apples last night.

If all your sentences are set up with a double x ("xx") in the middle, you
can use:

=SUBSTITUTE(A4,"xx",A1)

Otherwise you can use, =CONCATENATE("She ate ",A1," apples last night.")

If neither of these work submit more information to go on.

--
Regards,
Dave


"kyjilly" wrote:

For example if I have information in cell A1 but my sentece is in A4. I want
the information to show up in the middle of the sentece.

A1 = 5

she ate xx apples last night.