I have a set of text strings which all end in a number.
Currently what I am having to do is use this formula
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
But as there is no space but an "=" sign before the last number I am putting in the formula and then doing a find replace for = and replacing it with a space.
so for example I have the string
itemgg=321283
I put the formual in as above then replace the = with a space to return just 321283. Can I change the formula somehow to cut the find and replace out?
Cheers



Print Thread
deleted