Hi,
try :-if A1=300616a,then
B1=left(A1,6)=300616 (6 in the formula shows the first 6 in A1
Thank you,
K.S.warrier

"Frank Kabel" wrote:

Hi
try
=--LEFT(A1,LEN(A1)-1)

--
Regards
Frank Kabel
Frankfurt, Germany

"SusanK" schrieb im Newsbeitrag
...
I am trying to convert a number ending with a letter to just the
number. In
there a function in excel that can perform this task?