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.
|