Copy Left Word
 

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

Copy Left Word
 

If the tag number is a constant number of characters.

=LEFT(cell,"number of characters you want to show")

Regards,

Rikki

"Alectrical" wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

Copy Left Word
 

Thanks for your prompt reply, unfortunately, the number of characters can
vary between 2 and 6.

"Chiccada" wrote:

If the tag number is a constant number of characters.

=LEFT(cell,"number of characters you want to show")

Regards,

Rikki

"Alectrical" wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

Copy Left Word
 

Try this:

=LEFT(A1,FIND(" ",A1)-1)

Finds where the first space is and then extracts the characters to the
left of that.

Hope this helps.

Pete

On Jul 3, 11:23*am, Alectrical
wrote:
Thanks for your prompt reply, unfortunately, the number of characters can
vary between 2 and 6.



"Chiccada" wrote:
If the tag number is a constant number of characters.

=LEFT(cell,"number of characters you want to show")

Regards,

Rikki

"Alectrical" wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec- Hide quoted text -

- Show quoted text -

Copy Left Word
 

On Thu, 3 Jul 2008 03:00:02 -0700, Alectrical
wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

Since you give no examples of your data, is it safe to assume that the first
<space in your string separates the tag number from the description?

If so, you can use a formula, in the 2nd cell to the right, similar to:

=left(cell_ref,find(" ",cell_ref)-1)

IF not, you will need to provide more information.
--ron

Copy Left Word
 

Thanks Pete



"Pete_UK" wrote:

Try this:

=LEFT(A1,FIND(" ",A1)-1)

Finds where the first space is and then extracts the characters to the
left of that.

Hope this helps.

Pete

On Jul 3, 11:23 am, Alectrical
wrote:
Thanks for your prompt reply, unfortunately, the number of characters can
vary between 2 and 6.



"Chiccada" wrote:
If the tag number is a constant number of characters.

=LEFT(cell,"number of characters you want to show")

Regards,

Rikki

"Alectrical" wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec- Hide quoted text -

- Show quoted text -

Copy Left Word
 

Thanks Ron

"Ron Rosenfeld" wrote:

On Thu, 3 Jul 2008 03:00:02 -0700, Alectrical
wrote:

Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

Since you give no examples of your data, is it safe to assume that the first
<space in your string separates the tag number from the description?

If so, you can use a formula, in the 2nd cell to the right, similar to:

=left(cell_ref,find(" ",cell_ref)-1)

IF not, you will need to provide more information.
--ron

Copy Left Word
 

You're welcome.

Pete

On Jul 3, 3:52*pm, Alectrical
wrote:
Thanks Pete