HOW TO ADDING RUNNING TEXT INCLUDING NUMERIC DATA

[GVN KUMAR]

SIR,

"DETAIL PROJECT REPORT FOR TERM LOAN RS. __ AND WORKING CAPITAL Rs. __ FOR RUNNING OF NON TRADING RICE MILL". IT'S FRONT PAGE TITLE SIR,

IT IS A COMMON AND REGULAR TITLE OUR PROJECTS SIR ,

THE ABOVE LINE A SINGLE LINE AND ROW FORMAT JUSTIFICATION AND MERGED 9 COLUMNS OF ABOVE TEXT AND HEIGHT 85 THEN OK FOR DISPLAY PURPOSE

BUT EACH TIME WE ARE MANUALLY ENTERED NUMERIC FIGURES ABOVE LINE BEFORE OF Rs.

IT NUMERIC FIGURES AVAILABLE IN "COST" SHEET IT'S ANY TIME CHANGE AVAILABILITY OF COST OF UNIT. SO WE ARE MANUALLY ENTER IN COVER PAGE BEFORE PRINTING.

ANY FORMULA TO ADDING IN ABOVE LINE OR NUMERIC FIGURES OR TEXT MIXING IN ONE LINE IN NEW ROW. IT'S POSSIBLE WITH ANY FORMULA.

IN MS EXCEL ONLY SIR,

 

[Khalid NGO]

Hi Kumar,

Use hard-coded text in formula:
="DETAIL PROJECT REPORT FOR TERM LOAN RS. "&Sheet1!A1&" AND WORKING CAPITAL Rs. "&Sheet1!B1&" FOR RUNNING OF NON TRADING RICE MILL"


if you have single cell reference unlike above, you can use custom format too:
"DETAIL PROJECT REPORT FOR TERM LOAN RS. "#,##0

Regards,

 

[GVN KUMAR]

Thank you sir, good idea

 

[GVN KUMAR]

Sir it's beautiful & good idea sir

time save and printing cover page very nice thank you sir,

 

[Khalid NGO]

Sir it's beautiful & good idea sir

time save and printing cover page very nice thank you sir,

Welcome dear,
Glad it helped,

Keep visiting