Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append text repetition (2k)

    my boss asked me today: how could he add the text "NOTE" at the end of text already present in various cells that aren't in any particular order going down a column. so at first i thought of the F4 repeat button, but it only works for formatting it seems(?) so what i told him to do was to add another column. in the first cell that needs the note addition put =A1&"NOTE" and then select that cell and ctrl + click the other cells in the column below it that he wants to add it to and press ctrl + D to copy it down. that works, but i was wondering if there was a repeat button that could be used to repeat an append like used in this case. if it would take a macro to do that, forget it because my boss wouldn't put the effort in to make one. thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Append text repetition (2k)

    Not sure if this would be acceptable:
    - Select the cells you want to modify.
    - Select Format | Cells...
    - In the Number tab, select the Custom category.
    - In the Type box, enter @ "NOTE"
    This will only add the word NOTE in the display, not in the actual contents of the cells.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append text repetition (2k)

    yeah he wants to actually add the text "NOTE" to the content of the cells (atleast thats what it sounded like to me). I think he would want to be able to search for that text, or filter on it. i don't think you can do that if its only displayed, can you?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Append text repetition (2k)

    No, my suggestion doesn't help then. A formula it will have to be, I think, if a macro is not feasible.

Posting Permissions

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