Remove letters from text string
 

Hi

I run Excel 2K

I require a formula that removes the last 19 letters from a text string.

I have a number of varying lengths of text strings that require the last 10
letters being removed from each them.

Can anyone help?

Thanks

John

Remove letters from text string
 

One view on this
.. a formula that removes the last 19 letters from a text string.

Maybe something like this would suffice,
in B1, copied down:
=LEFT(A1,LEN(A1)-19)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Remove letters from text string
 

Thanks Max, works great !

John

"Max" wrote:

One view on this
.. a formula that removes the last 19 letters from a text string.

Maybe something like this would suffice,
in B1, copied down:
=LEFT(A1,LEN(A1)-19)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Remove letters from text string
 

Welcome, John. Glad it did.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John Calder" wrote in message
...
Thanks Max, works great !