How do embbed a cell within a sentence

K

kyjilly

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

David Billigmeier

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