| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
| Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
| How do i add a cell value in a sentence without using 2 cells? | Excel Worksheet Functions | |||
| How do embbed a cell within a sentence | Excel Worksheet Functions | |||
| how do i write a sentence in a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
