Posts by eddie57

  • Join Cells With Space

    I have a sentence in field A1 and a number in field A2. The formula I am using is =A1 & A2. This is working but there is no space in between A1 and A2. How can I add a space? Thanks in advance.

  • Join Text With Cell Value

    How does one add data to a field that has existing data? For example, say I have a list of different people names and want to say the word "visitor" at the end of each name how is that done for an entire list without have to do it one by one. Also how do I add a word to the beginning of a list of names as well? ANy help is appreciated. Please make it simple, as I am an average user. Just basic spreadsheets that add and multiply.


    Eddie


    PS: I am using Excel 2003.

  • Formula Error

    I am using this formula in an Excel worksheet. The formula is "=workday(K41,2)", which was giving me the date in field K41 plus 2 days. Now instead of the date I get "#NAME?". Anyone have an idea what went wrong?



    Thanks
    Eddie

  • Page Number

    I was sent an excel file and each page has in big font Page 1, Page 2, and so on. My question is: how do I remove these "Page numbers". Thanks



    Eddie

  • Amortization

    Re: Amortization


    That wasn't what I was looking for, but thanks. I found what I was looking for. This is the formula for calculating the payment on a mortgage by using the principal, interest rate and term of loan. Formula:
    =-ROUND(PMT(F2/12,F3*12,F1),2)


    The monthly payment on a $40,440.21 loan at 3 percent for 20 years is $224.28.
    Thanks

  • Amortization

    Can someone explain how to amortize a loan using excel. I currently use excel for all my work, but have been using lotus for amortizations because it's a template that one uses where you just plug in the amounts and interest and years. I want to get away from lotus completely and use Excel for everything.


    thanks

  • Borders

    When I click on the borders drop down box I only have solid lines. Is there a way to add dashed lines to this box. I know you can right click , format cells and do it that way, but that is more steps than i would like to use. If I could add it to the drop down box that would be great.


    thanks
    Eddie

  • Percentages

    Re: Percentages


    This is what i entered:


    =IF(ISBLANK(C3),"",B3/C3)


    I am not getting the ###, but I am getting "#DIV/0!". Did I do something wrong?


    Thanks
    Eddie

  • Percentages

    I have a file that has a percentage formula. since i dont have any numbers in the some the cells i am getting ### in the formula cell. How can I have excel not display anything there?


    thanks
    Eddie

  • Copy and paste special

    I have 2 excel files. One links to the other. It is a payable spreadsheet. Sometimes I have 1 item listed on file one, sometimes it's more than 3. I did a copy and paste special link from file 1 to file 2. The thing is than when I only have 1 item on file 1, file two will show a "0" when I don't have any data on file 1 to link to file 2. How can I eliminata the "0" from showing when I have no data on file one? Hope I made sense.


    Thanks
    Eddie

  • Wordperfect/Word

    I have a wordperfect file that has pictures in it. When I tried opening this file in word only the font was visible. Is there a way to get the pictures to open in word. I tried to copy the pictures in the WP file and paste them to Word, but it didn't work. Anyone have any idea on how I can get this to work?


    thanks
    Eddie

  • Date

    Re: Date


    WHat I meant to say what instead of the month being February I would like it to be FEBRUARY. I want all the letters capitalized. Sorry for the mix up.


    thanks
    Eddie

  • Date

    I have an excel worksheet where the current date is automatically inserted. What I would like to know is, how do I get Excel to capitalize the month automatically as well?


    thanks in advance,
    Eddie