LinkBack URL
About LinkBacks
I need a formula for removing the first few words from a cell.
For example, i need to take "5th dimension" from "5th dimension one less bell to answer"
and seperately to take "one less bell to answer" away.
I need a formula for removing the first few words from a cell.
For example, i need to take "5th dimension" from "5th dimension one less bell to answer"
and seperately to take "one less bell to answer" away.
In A1 cell
5th dimension one less bell to answer
In B1 cell
5th dimension
In C1 cell
=TRIM(SUBSTITUTE(A1,B1,""))
Change the cell reference to your desired cell.
Hope this helps!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In cell B1, would i have to manually type that in? or could i work around the formula you put in C1?
Replace the B1 with your text like the belowOriginally Posted by Luke Andrews
=TRIM(SUBSTITUTE(A1,"5th dimension",""))
Hope this helps!
that worked fine, but i have another 497 of these to doi need something that as a general rule would take out the first couple of words, after that i could go down and make slight amendments
Or do you need in B1, the first 2 words of any string in A1?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis, thats what im looking for
If you are comfortable in using User Defined Function or VBA Macro then post a sample data with the criteria's needs to be removed.that worked fine, but i have another 497 of these to do
In B1
=LEFT(A1,FIND(" ",A1,FIND(" ",A1,1)+1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks