Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Left Word
You're welcome.
Pete On Jul 3, 3:52*pm, Alectrical wrote: Thanks Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy down formulars into same column by a row left to righ | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Copy of Word document | New Users to Excel | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Making MIcrosoft Word type from Right to Left | Excel Discussion (Misc queries) |