| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Remove last character of text string
I need a function to drop that last chatacter of a text string. The text
strings vary in length bit I always need to remove the last string. Any suggestions? T.I.A. |
|
#2
|
|||
|
|||
|
=IF(A1<"",LEFT(A1,LEN(A1)-1),"")
On Thu, 29 Sep 2005 08:35:03 -0700, "Grant" wrote: I need a function to drop that last chatacter of a text string. The text strings vary in length bit I always need to remove the last string. Any suggestions? T.I.A. |
|
#3
|
|||
|
|||
|
Grant Wrote: I need a function to drop that last chatacter of a text string. The text strings vary in length bit I always need to remove the last string. Any suggestions? T.I.A. If your string is in, say, A1, this formula =LEFT(A1,LEN(A1)-1)) will delete the last character of your string. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=471812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
| Extracting from a text string | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Hybrid Mode
