Thanks:  0
Likes:  0

# Thread: Formula to copy partial content of a cell?

1. 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

2. 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
In B1 enter: =RIGHT(A1,2)

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

Is that what you're looking for?

3. 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. If I have a text
Weight = 60kg
How can I copy just the number 60(no kg included)?

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

6. 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. 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
Microsoft Excel/VBA Training

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

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

9. 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. 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

#### Posting Permissions

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