View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LAndersen LAndersen is offline
external usenet poster
 
Posts: 4
Default cutting characters from a cell

i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!