Formula required to pick a data from another cell in middle of a sentence in excel

[Manoj K]

I have an excel file, and having a small sentence “Please issue ____ ltr for batch preparation”. The blank cell data to be picked up from another cell in same sheet. Is there any formula to pick the data from another cell in middle of a sentence in excel.

 

[LegendaryAxe]

="Please issue "&A1&" ltr for batch preparation."

I'm using A1 here as an example. Use whichever cell reference contains the ltr amount.

 

[Manoj K]

It worked, but the data in my particular cell is containing value of figures from six rows. The result has to be in as per particular cell (figures in three decimal, eg. 60.010 ltr). In this formula pick up, there is no decimal stop. Can you please confirm any other formula to pick the data as same as data shown in particual cell. Thank you in advance.

 

[Sanjeev1976]

You can try :

="Please issue "&Fixed(A1,3)&" ltr for batch preparation."

 

[Manoj K]

You can try :

="Please issue "&Fixed(A1,3)&" ltr for batch preparation."

Thanks, it worked well