Formula to copy partial content of a cell?
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Formula to copy partial content of a cell?

  1. #1
    Guest

    Default

     
    Question:
    I am wondering is there an excel formula to copy one partial content of a cell to another cell?
    eg. Copy 90 from Weight-90 in a cell to another cell
    Thanks in advance

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,752
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-12 08:19, Anonymous wrote:
    Question:
    I am wondering is there an excel formula to copy one partial content of a cell to another cell?
    eg. Copy 90 from Weight-90 in a cell to another cell
    Thanks in advance
    In B1 enter: =RIGHT(A1,2)

    where A1 houses Weight-90, would result in 90.

    Is that what you're looking for?

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you want to just pull off the last two characters from a cell then you would use:

    =right(a1,2) where a1 is the cell in question.

    If it more complicated than that, let me know.

    Robin

  4. #4
    Guest

    Default

    If I have a text
    Weight = 60kg
    How can I copy just the number 60(no kg included)?
    Thanks in advance

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just select the cell, push F2, higlight it and copy.



  6. #6
    Guest

    Default

    I really need formula to do this
    because I have about 40000 of cells. If I do it one by one, it will take forever to get it done

  7. #7
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The can you use has has been suggested:

    =LEFT(D14,2)*1

    Will return a real number.

    If not is the number always followed by "kg"? If so use:

    =SUBSTITUTE(D14,"kg","")*1



    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training


    [ This Message was edited by: Dave Hawley on 2002-03-12 09:01 ]

  8. #8
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or even the Text to columns wizard under Data and using Delimited with "Other" and just "k" delimiter

  9. #9
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your entries always look like:

    Weight = 60kg or Weight = 103kg

    You can use the following and it will separate the number at two to three numbers:

    =IF(SEARCH("k",A1)=13,MID(A1,10,3),MID(A1,10,2))+0

    The formula is set up for the string in cell a1, change and copy appropriately.

    Cheers,

    Nate

    [ This Message was edited by: NateO on 2002-03-12 09:20 ]

  10. #10
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Might as well go 4 deep (weight from 1 to 4 didgits) at this point:

    =IF(SEARCH("k",A1)=11,MID(A1,10,1)+0,IF(SEARCH("k",A1)=12,MID(A1,10,2)+0,IF(SEARCH("k",A1)=13,MID(A1,10,3)+0,MID(A1,10,4))+0))

    Hope this helps. Cheers,

    Nate

    [ This Message was edited by: NateO on 2002-03-12 09:41 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com