i want to delete a part of a long string. how can i accomplish this. kindly see the attached file.
i want to delete a part of a long string. how can i accomplish this. kindly see the attached file.
Hi sumesh,
Find the attached with your answer.
The formula looks like this:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi, Try
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
=trim(right(substitute(b2,"– ",rept(" ",99)),99))
Last edited by azumi; 10-23-2014 at 01:36 AM.
MarvinP, your formula works fine. but when i -copy -paste special -formula -it gives error. i ahve to edit A2 to B2 then only it will give the result. when we -copy =pastespecial -formula it should adopt to the new cell address????see the attachement pls
Last edited by sumesh56; 10-23-2014 at 01:31 AM.
Change the cell ref A2 to B2
Formula:Please Login or Register to view this content.
okay I think this is very easy...
Simple Find and Replace will do the job..
Try find "*– "(without Quotes) and replace it will nothing..
the is not a normal hypen(-), copy and paste the above portion without quotes and replace it with nothing..
will definitely do the job..
Regards,
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
hi vikas,thanks for the direction. i was trying "find and replace" for several times. since i could only put a normal hypen it was not yeilding the required result. now that when i copy pasted the splcharacter it worked fine. i would like to ask you where on my keyboard can i find the spl character which is "hyphen- like" but NOT A HYPHEN. thanks
in this example ,how can I get the first part only?
01 – Oru Ragam – hwh.tantryum.om.mp3
02 – Enge En – jen.tantryum.om.mp3
03 – Thendral Vandhu – jtj.tantryum.om.mp3
I expect to get the result as
Oru Ragam .mp3
Enge En .mp3
Thendral Vandhu .mp3
Last edited by sumesh56; 10-23-2014 at 09:58 PM.
To get your "special symbol" try using the insert symbol dialog.
http://www.howtogeek.com/163481/how-...in-excel-2013/
Here is what you wanted...
Formula:Please Login or Register to view this content.
Check the attached file..
Here is one more alternative to this...
Formula:Please Login or Register to view this content.
check the attached file..
hi vikas,
when i copy -the formula and paste-paste special-formulas------then there is ref error. why this happens? when i copy and paste the formula it should adopt to the new cell reference. in this instance why it is not so? kindly explain. thanks
Try this..
Formula:Please Login or Register to view this content.
Change the red reference with your original one...
and drag down..
this one is a lot better..
Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks