Insert Cell Tex/Valuet into cell string

[m_789]

A1 = Customer Name
A3 = Age
A4 = Weight
A5 = Amount

so basically

Mr (A1) has visited us today, We can confirm his age at the time of visit was (A2) and his weight was (A4) the Cost for the test will be (A5) which needs to be paid ASAP

[aworfolk]

Try one of these

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[FDibbins]

You can also do this using the & sign...

="Mr "&A1&" has visited us today, We can confirm his age at the time of visit was "&A2&" and his weight was "&A4&" the Cost for the test will be "&A5&" which needs to be paid ASAP"

However, depending on the EXACT contents in A2:A5, you may need to include the TEXT() function to manage decimal places.

Maybe something like this...
="Mr "&A1&" has visited us today, We can confirm his age at the time of visit was "&A2&" and his weight was "&TEXT(A4,".00")&" the Cost for the test will be "&A5&" which needs to be paid ASAP"

[newdoverman]

Is this part of a larger problem where you have many names, ages etc. listed in a column or columns to be use in a merge with text?