Page 1 of 3 123 LastLast
Results 1 to 15 of 38
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using forumula in Word (2000)

    Hi,

    I am trying to use a formula in Word , as l would like to put the description, stock code and bar code into a label for printing out (see attachment).
    But l work out a way to put the following formula into Word.

    =CONCATENATE("*",UPPER(B3),"*")

    Is there any way this formula can be put into Word so l can produce the labels in Word or if not what would be the best way to produce the labels in Excel?

    Any assistannce would be appreciated.

    Justin
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forumula in Word (2000)

    Word doesn't have an extensive set of functions. You could create a table in Excel, with suitable column headings. You can then use this as data source for a mail merge to labels in Word.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    Can you explain as to how l go about doing this please?
    As l am not to sure how to use the mail merge facility?
    see attachment for the spreadsheet l am using which l required to be merged into Word.

    Justin.
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    This is the word document which contains the document with the labels where l would like to put the barcode.
    see attachment.

    Justin
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forumula in Word (2000)

    The sample labels don't use the result of the formula in Excel. What exactly do you want to appear on the labels?

  6. #6
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    LRU Description i.e Cockpit Control Unit , Stock Number , i.e. DYT6238A2 and the barcode

    Justin.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forumula in Word (2000)

    The attached document contains a table with merge fields. You will have to apply the barcode font yourself in the Word doc (I don't have the one you need) and you will have to run the mail merge helper to connect to the workbook. I deleted the first row in the workbook, so that the data table starts in row 1.
    Attached Files Attached Files

  8. #8
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    I have put in the barcode font but still cannot get Word to read it.
    I have tried but no luck , it does not appear to show as a merge field and l cannot work out why this is.

    Regards
    Justin

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forumula in Word (2000)

    You must apply the barcode font in the Word document, not in the Excel spreadsheet.

  10. #10
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Using forumula in Word (2000)

    > I have put in the barcode font but still cannot get Word to read it.

    Generally speaking, the bar code font supplier (I think we bought ours from Elfring?) should let you know if any special set-up is required to use the font on your version of Windows and Word. As the next step, the font supplier's software for converting your number into a bar code should be tested. In the case of the one we use (Code128?), special characters are added to the beginning and end of the text string, which I suppose constitute some sort of checksum or other aid to reading the bar code. You can copy and paste from the "bar code maker" program into Word. In order to merge, you might have to create a Word field or a formula in Excel to produce the complete string before it will be rendered properly by the font.

    Hope this helps.

  11. #11
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Using forumula in Word (2000)

    Sorry, I just saw the other thread. macropod has made a couple of star posts explaining how to work incredible magic with field codes. There is one that would be similar to the CONCATENATE function, but unfortunately I cannot remember what it is. Maybe {QUOTE}? If the help for {QUOTE} doesn't help, look up macropod's <post#=365442>post 365442</post#> and <post#=249902>post 249902</post#> on this board for additional inspiration.

  12. #12
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    I don't really know what l am looking for?
    I assume it is a field code in Word which can use the concatinate feature?
    I don't understand what you mean by (QUOTE) feature? Again l don't really know what l am looking for.
    If you explain in a bit more detail that would be much appreciated as this would make it easier to find.


    Justin

  13. #13
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    I have looked a macropods post but cannot find such a feature, any ideas as to where else l could look?

    Justin

  14. #14
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Using forumula in Word (2000)

    {QUOTE} is a field code. See the attached illustration for how QUOTE concatenates plain text and the results of other field codes.
    Attached Images Attached Images

  15. #15
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forumula in Word (2000)

    How would l use it put the formula:

    =CONCATENATE("*",UPPER(B3),"*")

    which is a formula for a barcode in an excel spreadsheet

    Justin.

Page 1 of 3 123 LastLast

Posting Permissions

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