EXcel Del text - other than-start letters MB
Closed
anand
-
Mar 20, 2009 at 02:18 AM
password00 Posts 23 Registration date Tuesday December 30, 2008 Status Member Last seen June 18, 2009 - Mar 21, 2009 at 03:01 AM
password00 Posts 23 Registration date Tuesday December 30, 2008 Status Member Last seen June 18, 2009 - Mar 21, 2009 at 03:01 AM
Related:
- EXcel Del text - other than-start letters MB
- Keyboard won't type letters - Guide
- Gta v free download for pc low mb - Download - Action and adventure
- How to start a listening party on spotify pc - Guide
- Keyboard letters not working but numbers are - Guide
- Excel date format dd.mm.yyyy - Guide
1 response
password00
Posts
23
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
June 18, 2009
11
Mar 21, 2009 at 03:01 AM
Mar 21, 2009 at 03:01 AM
hi,
You can use the function SEARCH to find the position of the letters in the text, and then the function LEFT to retrieve only the portion of the text before it.
=LEFT(A1:<how much you have>,SEARCH("<the letters you need to remove>",A1:<how much you have>)-1)
You can use the function SEARCH to find the position of the letters in the text, and then the function LEFT to retrieve only the portion of the text before it.
=LEFT(A1:<how much you have>,SEARCH("<the letters you need to remove>",A1:<how much you have>)-1)