Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut the last 20 characters out of a text string
Hi, I have a column with text in each cell but the length of the text string
varies in each cell. However I would like to remove the last 20 characters of the text string. I could do this if I wanted to only show the last 20 characters by using right(a1,20) but I cannot use the left function because the length of the text string varies depending on the name of the person. EG The first 2 cells are Lott M 123456789101234567890 Peterson D 123456789101234567890 And I would like them to say Lott M Peterson D I'm sure there will be a simple way of doing this but can't find one. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove unwanted characters within a text string. | Excel Discussion (Misc queries) | |||
Text String - Specific Characters | 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 | |||
Insert characters in a text string | Excel Worksheet Functions |