| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove number from text string | Excel Worksheet Functions | |||
| remove text from string | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Hybrid Mode
