cell insertion in a sentence
 

hello again,,

how can i insert a cell on a sentence.. like this TOTAL CARGO
ON-BOARD:MAWB:(at cell A1)/PCS:(cell A2)/AWT:(cell A3) KGS/CWT:(cell A4) KGS

thanks...

cell insertion in a sentence
 

Try the concat operator: &
Eg in A5:
="TOTAL CARGO ON-BOARD:MAWB:"&A1&"/PCS:"&A2&"/AWT:"&A3&"KGS/CWT:"&A4&" KGS
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"RYNNER" wrote:
how can i insert a cell on a sentence.. like this TOTAL CARGO
ON-BOARD:MAWB:(at cell A1)/PCS:(cell A2)/AWT:(cell A3) KGS/CWT:(cell A4) KGS

cell insertion in a sentence
 

Hi,

Just a slight change to the previous suggestion:

="TOTAL CARGO ON-BOARD:MAWB: "&A1&" /PCS: "&A2&" /AWT: "&A3&" KGS/CWT:
"&A4&" KGS"

I can't be sure what spacing you want but you do need a " at the end.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RYNNER" wrote:

hello again,,

how can i insert a cell on a sentence.. like this TOTAL CARGO
ON-BOARD:MAWB:(at cell A1)/PCS:(cell A2)/AWT:(cell A3) KGS/CWT:(cell A4) KGS

thanks...

cell insertion in a sentence
 

.. but you do need a " at the end.
Agreed, thanks for correction
Missed that last: " in the copy / paste earlier
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---