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

[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?

 

[Pete_UK]

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

=LEFT(A1,16)

Hope this helps.

Pete

 

[Copy Bear]

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

Thank you

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

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

Thank you





- Show quoted text -

 

[Sheri Lynn]

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

 

[Pete_UK]

Well, how many characters do you want to extract? Suppose it is 5:

=RIGHT(A1,5)

Hope this helps.

Pete

 

[Adi Wessels]

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

=LEFT(A1,16)

Hope this helps.

Pete

Thanks Pete. short & to the point exactly what I needed.

 

[Adi Wessels]

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

=LEFT(A1,16)

Hope this helps.

Pete

Thanks Pete. short & to the point exactly what I needed.

 

[Adi Wessels]

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?

What if I need the middle 8 numbers?