 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Remove 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 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)  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- Thanks Max, works great ! John > 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) Welcome, John. Glad it did. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Thanks Max, works great !
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.