How do a insert data within text in Excel please?

How do I insert data from a particular cell into the middle of text please?
I am typing in 'the issued share capital is "&DATA!G15" ordinary shares of £1 each'
Cell G15 of the worksheet named 'Data' holds the number '100', being the total issued shares capital.
I'm getting an error message, so obviously (or not so obviously to me!) I'm doing something wrong.
Is it because I'm entering this longhand, and maybe I should be using something from the toolbar?
Please can someone help?
Thanks.
David Evans

Comments
There are 5 comments. Login or register to view them.

Try also the 'Concatenate' function

Richard Willis |
Richard Willis's picture

TEXT

martincassis |

One problem and three solutions!

newmoon |

Missing a "&" sign

AnonymousUser |

What you are doing wrong

andymeeson |