| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a word from end of a text
Thanks for replies.
"Pete_UK" wrote in message oups.com... Yes, you're right David -I just spotted trimleft in Gary's posting and thought that isn't a function! Pete David Biddulph wrote: I'm not convinced that it does help, Pete, or Gary. In your formula right(A1,len(A1)-8)) will remove the first 8 letters from the text string, and give you the remaining right-hand end of the string. You are then using that string as the second argument for the left function, which not surprisingly returns a #value error. Perhaps you intended to suggest =TRIM(LEFT(A1,LEN(A1)-8)) -- David Biddulph "Pete_UK" wrote in message ups.com... Slight correction, Gary: =trim(left(A1,right(A1,len(A1)-8))) Hope this helps. Pete Gary L Brown wrote: good point - use a helper column =trimleft(A1,right(A1,len(A1)-8)) -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "romelsb" wrote: Hi gary, Mr. Rasoul has a tricky question....watch out for the advice if there is a word "function" in the beginning or mid of the text in any colum----result may be devastating for him? maybe u can suggest some basic formula. "Gary L Brown" wrote: use FIND/REPLACE. Find Function and Replace with HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Rasoul Khoshravan" wrote: I have a column of texts. All of texts have the word "function" at end of them. I want to delete this word from end of all texts. How can I do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
| How to export text from Excel to Word | New Users to Excel | |||
| moving text from a word document to excel | New Users to Excel | |||
| Why am I getting XXX error in text cell with word wrap turned on? | Excel Discussion (Misc queries) | |||
| Copying text to Word doc | Excel Discussion (Misc queries) | |||
Hybrid Mode
