View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 90-80 split the text this "-" formula

hi,
try...
=MID(F1,4,10)

regards
FSt1

"USA" wrote:

I need help spliting a cell with a formula after a character.
this is the result i need 80

problem result
90-80 80

the number on the right is different in lengh, 2 number or 5 number to the
right of "_"