Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    352

    Worked fine for me....alternatively

    Try pasting this code (taken from what I recorded and renamed) in a module in your personal.xls or in a module in the workbook where you perform this action:



    Sub PasteLink()
    ...
  2. did you even try my simple solution?

    I can see your dilemma, but by pulling the data in and out of word, you do actually get rid of all the alt-enter soft returns. Perhaps you can figure out what that is doing and integrate it into your...
  3. Replies
    3
    Views
    352

    Not sure how to do what you ask, but here's an alternative

    Record a macro where all you do is select "paste as link". Then you can assign the macro a shortcut like CTRL-N or something you can easily hit. Or you can even give it an icon in your toolbar to...
  4. This isn't the best solution but

    When I'm faced with this, I copy the cell or cells from excel into word. I then copy them back into excel and voila!

    Of course you are then faced with removing the blank rows, but that can be...
  5. Replies
    4
    Views
    320

    That's why you're the MVP! Much better solution...

    That's why you're the MVP! Much better solution than mine :-P
  6. Replies
    4
    Views
    320

    Try this

    How about
    =MID(D3,FIND(" ",D3)+1,LEN(D3))?

    This should give you what you want assuming the text you want is always right after the first space in the cell.
  7. Replies
    3
    Views
    327

    J5=If(isna(VLOOKUP(H5,'CASS...

    J5=If(isna(VLOOKUP(H5,'CASS Data'!$D$598:$I$614,2,FALSE)),"",VLOOKUP(H5,'CASS Data'!$D$598:$I$614,2,FALSE))
  8. Replies
    5
    Views
    354

    How about a custom function

    I found this in Mr. Excel's tips. It worked for me.

    http://www.mrexcel.com/tip012.shtml
  9. Replies
    3
    Views
    218

    Try this

    Assuming your name formatted last name, first name is in cell P1

    The formula you would enter in cell BB1 would be:
    =MID(P1,FIND(", ",P1)+2,LEN(P1))&" "&LEFT(P1,FIND(", ",P1)-1)
  10. Replies
    5
    Views
    354

    heights

    Any chance you could have two columns for the height? One for feet and one for inches? Then you would only need to use the mod function in your sums for the two columns.
  11. Try this

    So, I assume it is another cell in which you are setting this conditional formatting? If so, try this (assume you are setting it in cell C4)

    As your third conditional format select "formula is"...
  12. Replies
    3
    Views
    293

    Validation

    Hey,

    Enter the formulas in some other cells on your worksheet (say cells AA1:AA5 and then just reference them in the data validation.

    Make sense?


    James
  13. I figured it out on my own!

    I was surprised at no response and am curious what I could have done differently to pique enough interest for some help. This board has saved me in the past, but this time I wasn't so lucky.

    It...
  14. So I spent a portion of time today on this and am stumped

    I have to assume that I've taken the totally wrong path here.

    Extra info:
    As the macro suggests, n & m are the upper and lower bounds upon which a is calculated.
    I've oversimplified this, but...
  15. Pulling VBA formulas from worksheet for calculation

    Hello wonderful gurus! It's been a long time since I posted here.

    I am bumbling about trying to do something that I am not even sure I can explain. Here's my attempt:

    I would like an end-user...
  16. Replies
    3
    Views
    295

    Re: Help PLease!

    try: =C5-SUM(E5:F5)
  17. Re: Find the nth occurence of a character in a text string

    Does anyone have a VB solution?
  18. Re: Find the nth occurence of a character in a text string

    There is always a space after the hyphen, so by using the +2, I get to the first letter of the word following.

    Unfortunately I cannot be assured that the 3rd hyphen will be the last, so I need to...
  19. Re: Find the nth occurence of a character in a text string

    Perfect! Thank you.

    So to isolate all of the text after the third hyphen, I use the formula:

    =MID(A1,FIND(CHAR(127),SUBSTITUTE(A1,"-",CHAR(127),3))+2,LEN(A1))

    I know that there are no...
  20. Find the nth occurence of a character in a text string

    Does someone know of either a formula or VBA code to locate and give the position of the nth occurence of a character in a text string in a cell?

    For example:

    If cell C5 = "Colorado - 1995 -...
  21. Replies
    3
    Views
    344

    Re: Function select unique

    Check out this thread.
    http://www.mrexcel.com/board2/viewtopic.php?t=89702&highlight=
  22. Replies
    10
    Views
    620

    Re: Advanced Filter

    Understood.

    Can you provide an example of the code you are using for the filter? I think that the only possibility will be another workaround (given your definition), but you never know.
  23. Replies
    10
    Views
    620

    Re: Advanced Filter

    Wouldn't these two lines placed in your code just after the advanced filter work?



    Range("C1:C100").Select
    Selection.ClearFormats


    You only need to replace "C1:C100" with the range where...
  24. Replies
    10
    Views
    620

    Re: Advanced Filter

    elgringo56,

    As far as I know when you use data/filter/advanced filter, and copy to another location, you have no choice but for the formats to come along. Perhaps someone could provide a piece of...
  25. Replies
    6
    Views
    435

    Re: Classing an #N/A as a zero value

    Actually, http://www.mrexcel.com/board2/viewtopic.php?t=48679
Results 1 to 25 of 61
Page 1 of 3 1 2 3