How to copy part of a cell into a new cell?

  • Thread starter Thread starter Copy Bear
  • Start date Start date
C

Copy Bear

I want copy the cell with 20 numbers and letters to another cell but only
with first 16 numbers and letters. example: the cell contains
"8EC284B95EB84783A099" but I only need the first 16 numbers or letters
"8EC284B95EB84783" to a new cell. Is any formula can do it?
 
Assuming your 20 character string is in A1, then put this in B1:

=LEFT(A1,16)

Hope this helps.

Pete
 
Can you tell me how to do the same thing from the right side? I tried =RIGHT(A1, ), but not sure what else to put in the parenthesis.



Pete_UK wrote:

You're welcome - thanks for feeding back.
01-Mar-08

You're welcome - thanks for feeding back

Pet

wrote
l

uoted text -

Previous Posts In This Thread:

How to copy part of a cell into a new cell?
I want copy the cell with 20 numbers and letters to another cell but only
with first 16 numbers and letters. example: the cell contains
"8EC284B95EB84783A099" but I only need the first 16 numbers or letters
"8EC284B95EB84783" to a new cell. Is any formula can do it?

Assuming your 20 character string is in A1, then put this in
Assuming your 20 character string is in A1, then put this in B1

=LEFT(A1,16

Hope this helps

Pete

Yes. It works.
Yes. It works. It save me lots of time to modify the work shee

Thank yo

:

You're welcome - thanks for feeding back.
You're welcome - thanks for feeding back

Pet

wrote
l

uoted text -


Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorial...d8-3e2773fa29b5/whats-new-for-developers.aspx
 
Well, how many characters do you want to extract? Suppose it is 5:

=RIGHT(A1,5)

Hope this helps.

Pete
 
Copy Bear said:
I want copy the cell with 20 numbers and letters to another cell but only
with first 16 numbers and letters. example: the cell contains
"8EC284B95EB84783A099" but I only need the first 16 numbers or letters
"8EC284B95EB84783" to a new cell. Is any formula can do it?
Click to expand...
What if I need the middle 8 numbers?
 
Back
Top