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