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

"Copy Bear" <Copy Bear @discussions.microsoft.com> wrote in message
news:B50C343C-46DA-460D-AD25-(E-Mail Removed)...
>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?

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

Thank you

"Pete_UK" wrote:

> Assuming your 20 character string is in A1, then put this in B1:
>
> =LEFT(A1,16)
>
> Hope this helps.
>
> Pete
>
> "Copy Bear" <Copy Bear @discussions.microsoft.com> wrote in message
> news:B50C343C-46DA-460D-AD25-(E-Mail Removed)...
> >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?
>
>
>

You're welcome - thanks for feeding back.

Pete

On Mar 1, 1:54*am, Copy Bear <Copy B...@discussions.microsoft.com>
wrote:
> Yes. *It works. *It save me lots of time to modify the work sheet
>
> Thank you
>
>
>
> "Pete_UK" wrote:
> > Assuming your 20 character string is in A1, then put this in B1:
>
> > =LEFT(A1,16)
>
> > Hope this helps.
>
> > Pete
>
> > "Copy Bear" <Copy Bear @discussions.microsoft.com> wrote in message
> >news:B50C343C-46DA-460D-AD25-(E-Mail Removed)...
> > >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?- Hide quoted text -
>
> - Show quoted text -

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:

On Friday, February 29, 2008 7:36 PM
Copy Bear wrote:

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?

On Friday, February 29, 2008 7:41 PM
Pete_UK wrote:

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

On Friday, February 29, 2008 8:54 PM
Copy Bea wrote:

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

Thank yo

"Pete_UK" wrote:

On Saturday, March 01, 2008 4:17 PM
Pete_UK wrote:

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/tutorials...evelopers.aspx

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

=RIGHT(A1,5)

Hope this helps.

Pete

On Feb 16, 3:54*pm, Sheri Lynn wrote:
> 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.
>
> Pete
>
> wrote:
> ly
>
> uoted text -
>
> Previous Posts In This Thread:
>
> On Friday, February 29, 2008 7:36 PM
>
> Copy Bear wrote:
>
> 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?
>
> On Friday, February 29, 2008 7:41 PM
>
> Pete_UK wrote:
>
> 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
>
> On Friday, February 29, 2008 8:54 PM
>
> Copy Bea wrote:
>
> Yes. *It works.
> Yes. *It works. *It save me lots of time to modify the work sheet
>
> Thank you
>
> "Pete_UK" wrote:
>
> On Saturday, March 01, 2008 4:17 PM
>
> Pete_UK wrote:
>
> You're welcome - thanks for feeding back.
> You're welcome - thanks for feeding back.
>
> Pete
>
> wrote:
> ly
>
> uoted text -
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> What's New for Developers in SharePoint 2010 Object Model?http://www.eggheadcafe.com/tutorials...5c-49b7-a0d8-3...