90-80 split the text this "-" formula
 

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

90-80 split the text this "-" formula
 

One way:

=RIGHT(A1,LEN(A1)-FIND("-",A1))

HTH,
Paul

--

"USA" wrote in message
...
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 "_"

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