Results 1 to 3 of 3

Thread: Excel Question- Presume Its Easy for an Expert/Novice

  1. #1
    Squeeler Vini's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield
    Posts
    1,769
    Thanks
    44
    Thanked
    8 times in 8 posts

    Excel Question- Presume Its Easy for an Expert/Novice

    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.

  2. #2
    Registered User
    Join Date
    Sep 2005
    Location
    Somewhere in the Midlands :)
    Posts
    2
    Thanks
    0
    Thanked
    0 times in 0 posts
    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

  3. #3
    Squeeler Vini's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield
    Posts
    1,769
    Thanks
    44
    Thanked
    8 times in 8 posts
    ive done it using: ="NO." & D11 & " - " & E11 & "M" & " QTY=" & F11

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 23-09-2005, 02:55 PM
  2. Really easy to Win – Amacrox Rubber Suspension Kit
    By [FSP] Grace in forum General Discussion
    Replies: 43
    Last Post: 03-08-2005, 09:13 AM
  3. Quick and easy question!
    By planetgong in forum Help! Quick Relief From Tech Headaches
    Replies: 4
    Last Post: 01-03-2005, 06:25 PM
  4. Noisy fan? An easy fix...
    By Steve in forum Help! Quick Relief From Tech Headaches
    Replies: 4
    Last Post: 10-06-2004, 08:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •