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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Copy Bear - 01 Mar 2008 00:36 GMT

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?

Reply to this Message

Pete_UK - 01 Mar 2008 00:41 GMT

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

=LEFT(A1,16)

Hope this helps.

Pete

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

Reply to this Message

Copy Bear - 01 Mar 2008 01:54 GMT

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

Thank you

> Assuming your 20 character string is in A1, then put this in B1:
>
[quoted text clipped - 8 lines]
> > "8EC284B95EB84783A099" but I only need the first 16 numbers or letters
> > "8EC284B95EB84783" to a new cell. Is any formula can do it?

Reply to this Message

Pete_UK - 01 Mar 2008 11:35 GMT

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
>
[quoted text clipped - 14 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: