Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How can I copy specific content from other cells? (excel 2000)

    Is there a way to copy specific content from one cell to another? For example; the content in one cell is "AKRON 120 - SNSET 120 - 1". How can I write a command that will allow me to write "AKRON-SNSET - 120" into another cell without having to write it myself in this fashion (very long list). There are the same amount of characters and symbols in each cell that is decribed above.

    Thanks

    LaMont

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How can I copy specific content from other cells? (excel 2000)

    Hi LaMont

    If I understand correctly, all cells are in the format "XXXXX NNN - XXXXX NNN - N" If so the following will work.
    =LEFT(A1,5) & "-" & MID(A1,13,5) & " - " & MID(A1,19,3)

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How can I copy specific content from other cells? (excel 2000)

    Thanks alot - works perfect!

    LaMont

Posting Permissions

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