Search:

Type: Posts; User: kiazd; Keyword(s):

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    10
    Views
    619

    Re: Separating Names (XP)

    Unfortunately when I use your formula I get the following result.
    SmithBob Smith Bob
    BrownAlice Brow nAlice
    TurnerDoug Turn erDoug
    SharpMary Sh arpMary
    WilsonDick Wi lsonDick
    StevensSam ...
  2. Replies
    10
    Views
    619

    Re: Separating Names (XP)

    Thanks. Let's hope that someone does not have a very long first name <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> And you explanation is very clear.
  3. Replies
    10
    Views
    619

    Re: Separating Names (XP)

    Thanks, the coding worked. Just one question regarding strFirst = Mid(cCell, 1, 99), what does the 99 refer to?
  4. Replies
    10
    Views
    619

    Re: Separating Names (XP)

    Thanks, i will give it a try.
  5. Replies
    10
    Views
    619

    Re: Separating Names (XP)

    The names are in the format of last name, first name so why they are not being exported in that way is the reason for the question. Thanks.
  6. Replies
    10
    Views
    619

    Separating Names (XP)

    Exported a contact list from Outlook into Excel. Names in column A are in this format SmithBob. A variety of lengths in the names.Is there a method of using a function such as Mid to find the...
  7. Replies
    5
    Views
    595

    Re: VBA Not working (2007)

    The spreadsheet is attached. The code I found on the web. It worked fine in XP and 2000. As you can see you are to click on a cell in Col A and a pop-up calendar should appear. I have allowed...
  8. Replies
    5
    Views
    595

    VBA Not working (2007)

    Recently upgraded to 2007. Have found that some of the VBA coding from Excel XP does not function in 2007.Do I have to do a bunch of re-coding (ugh) or is there a simpler method to convert the XP...
  9. Replies
    3
    Views
    464

    Re: Dleted Mail (2003)

    The answer to all three questions is no. I have watched what she is doing and she is merely clicking delete. Our policy is not to allow third party software. She knows nothing about making rules....
  10. Replies
    2
    Views
    353

    Countif across a number of sheets (XP)

    I have 8 tabs labeled as A-C though V-Z for alphabetical purposes. If I use =Counta('a-c:v-z'!A3:A312) I can get a count of all names in column A for the workbook. If I try...
  11. Replies
    3
    Views
    464

    Dleted Mail (2003)

    When a user deletes an email, it does not go into the Deleted folder. Is there a setting in 2003 that she may have set that causes this to happen? I can recover the Deleted email with the recover...
  12. Replies
    7
    Views
    961

    Re: Create Template from Word (2003)

    Just wondering if in an oft file, you can insert form fields and then protect it as you can in Word. Looking at a way to create an oft where the enduser would only have to insert address and then...
  13. Replies
    2
    Views
    413

    Removing Signatures (2003)

    When I try to remove signatures in Outlook 2003, I find that they return when I restart my computer. I go to the Signature setting in Mail Format, remove the signatures without problem. They do not...
  14. Replies
    1
    Views
    401

    23:00 UCT and Above

    Just wondering what is happening. Each time I attempt to log on to the forum and the time is greater than 23:00 UCT (15:00 UCT my time) I find an extremely slow connection. Is this a case of all the...
  15. Replies
    1
    Views
    352

    Column Widths (XP)

    Column A to F is one set of data. Columns I to N another set of data.
    I don't believe this is possible, but a client wants to know if it is possible to adjust the width of the columns in the first...
  16. Replies
    1
    Views
    343

    Data Validation list (XP)

    Sheet 2 has the all of the State names. List has been named States. Sheet one has data validation based on this list. Instead of dragging down through the list to find a State to select I would like...
  17. Replies
    2
    Views
    420

    Re: Snooze Reminders (Outlook 03)

    Thanks, Hans. I was afraid of that.
  18. Replies
    2
    Views
    420

    Snooze Reminders (Outlook 03)

    In Outlook 03 you can set the default reminder time by going to TOOLS|OPTION. Assuming that I would like a reminder to come up 20 minutes before the appointment, is there any way to set the Snooze...
  19. Replies
    2
    Views
    449

    Re: Drop Down Calendar (Excel '07)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    http://www.fontstuff.com/vba/vbatut07.htm Found this site quite some time ago. Does this do what you want?
  20. Replies
    6
    Views
    1,153

    Re: Outlook 03 and xfd files (Outlook 03)

    It would appear that Han's solutiondoes not work. For some reason "Always use this program....." does not hold when checked. This problem just started happening when we up-graded to Outlook 03. If...
  21. Replies
    6
    Views
    1,153

    Re: Outlook 03 and xfd files (Outlook 03)

    Thanks Hans, but corporate policy will not allow us to download. We use Adobe Form Client which should open them. For this one user only, we have them opening in html format.
  22. Replies
    6
    Views
    1,153

    Outlook 03 and xfd files (Outlook 03)

    I have a client who when attempting to open xfd files linked in an Outlook message, has the xfd file open in HTML format. She sees all the coding rather than the document. I have checked various...
  23. Replies
    4
    Views
    630

    Re: Margin Indicators in Print Layout View (XP)

    Turns out I had two folders for MSOffice Tools. Found the correct folder and was able to turn off Chinese languages. thanks for the help.
  24. Replies
    4
    Views
    630

    Re: Margin Indicators in Print Layout View (XP)

    I see only the crop marks as in picture B. When I go to Microsoft Office Tools the only thing I see is about Save my Setting Wizard. There is nothing Languages as suggested in the article you...
  25. Replies
    4
    Views
    630

    Margin Indicators in Print Layout View (XP)

    Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>

    This is a very minor problem, but how does one get rid of the margin indicators in print layout view? I read...
Results 1 to 25 of 362
Page 1 of 15 1 2 3 4