Stripping mixed number and text
 

I have a field with mixed numbers and text (i.e. 232.4Ft). I want to strip of
the unit of measure (i.e. Ft) and have one field with the number and another
with the unit of measure. Can this be done? I am fairly confident I could do
it in VB, but I am not sure how at this point. Is there a worksheet function?

Thanks in advance!

Kevin

Hi
if your values have always this format you could use the following
formulas:
=LEFT(A1,LEN(A1)-2)
and
=RIGHT(A1,2)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kevin" schrieb im Newsbeitrag
...
I have a field with mixed numbers and text (i.e. 232.4Ft). I want to
strip of
the unit of measure (i.e. Ft) and have one field with the number and
another
with the unit of measure. Can this be done? I am fairly confident I
could do
it in VB, but I am not sure how at this point. Is there a worksheet
function?

Thanks in advance!

Kevin

Frank,

Thanks! That is exactly what I needed!

"Frank Kabel" wrote:

Hi
if your values have always this format you could use the following
formulas:
=LEFT(A1,LEN(A1)-2)
and
=RIGHT(A1,2)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kevin" schrieb im Newsbeitrag
...
I have a field with mixed numbers and text (i.e. 232.4Ft). I want to
strip of
the unit of measure (i.e. Ft) and have one field with the number and
another
with the unit of measure. Can this be done? I am fairly confident I
could do
it in VB, but I am not sure how at this point. Is there a worksheet
function?

Thanks in advance!

Kevin