How do embbed a cell within a sentence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif or please advice 1
countif or please advice 4
How do I fix the number of spaces after a sentence? 2
translating countifs function to Excel 2003 4
How do I keep the bold font when I copy an paste a document into W 3
Finding Text in a cell 3
Comparison of columns using Conditional Formatting 3
Calculations 1

Back
Top