View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kees Vos[_2_] Kees Vos[_2_] is offline
external usenet poster
 
Posts: 9
Default Get section of text from cell

Hey,

A long row of cells contains a item number and a item name, something like
this:
123456, item name
I only need the item number as a result. Is there a way to extract only the
text in front of a seperation mark (in this case the , )?

Note, the item number can contain numbers and/or letters and a interspace.

Thanks!