Thread: Copy Left Word
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chiccada Chiccada is offline
external usenet poster
 
Posts: 18
Default 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