This works...Thank you so much. Can you please provide me with similar
function for MS Access database as well?
RM
On Sat, Aug 15, 2009 at 1:18 AM, Serghei Ovanesov wrote:
> Hello,
>
>
> To remove starting letters from the cell the following nested function can
> be used:
>
>
>
> =RIGHT("00"
Hello,
To remove starting letters from the cell the following nested function can be
used:
=RIGHT("00"&RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1),6)
Where A1 = "ABC Company 435"
Assuming only 6 digit number is expected.
Regards.