I need one formula to delete certain amount of words from cell. I need the solution to delete certain amount of words not characters.
Delete x amount of words from beginning of cell... example delete 3 words
Example: I need a new bike
Output: new bike
Hope someone can help! Thanks!
Try this one in B1
=TRIM(SUBSTITUTE(A1,TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99)),99*3)),""))
Row\Col I need a new bike new bike
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Worked perfect thank you so much man!
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).
Here's another one...
=MID(A1,FIND("^",SUBSTITUTE(A1&" "," ","^",3))+1,100)
Assumptions:
There will be at least 3 words in the cell.
There will not be consecutive space characters.
The number of words to delete will always be >0.
The number of words to delete will never be greater than the actual number of words in the cell.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks