How would I go about printing/displaying text from cells in a sentence.
Like:
"" NO.'D2' - 'E2'M QTY='F2' ""
i want to have text then in the cell bits, want to read from the cell questioned.
How would I go about printing/displaying text from cells in a sentence.
Like:
"" NO.'D2' - 'E2'M QTY='F2' ""
i want to have text then in the cell bits, want to read from the cell questioned.
The simpliest way is to use the concatenate command...
Using the example that you have used it would be...
=concatenate("NO.",D2," - ",E2,"M QTY=",F2)
Or something close to that...
Hope that helps...
-----
FireExit
ive done it using: ="NO." & D11 & " - " & E11 & "M" & " QTY=" & F11
There are currently 1 users browsing this thread. (0 members and 1 guests)