Hi frens, i am new to excel. I've recieved a task to removes WORD duplicates within the cell.
Eg:
1234 International sunny sunny 4 floor Street 123
I want to remove only sunny from the sentence as its duplicate in the sentence. Like this i have more than 1000 records. Kindly help me out and suggest some tricks.
It should be :
1234 International sunny 4 floor Street 123
Thanks
Last edited by shakir4u21; 07-05-2014 at 03:12 PM. Reason: briefly explained
can you upload a sample book!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Didnt recieve sample book yet... but its like this :
107 Jeffer Jeffer Ave
50 Plume Ste 60
497 Inter Pkwy Pkwy Bldg Ste
26 Textile Rd
11830 Canon Blvd Ste Blvd
4808 Radford Ave
Duplicate words may occur only in few coloumns.
assuming your data is in A1 then in D1 copy paste below then hold control and shift together and then hit enter to make it array formula then drag down
Formula:
Please Login or Register to view this content.
find attached book
Thanku so much.. It works...
if this solves your query then mark the thread as solved and if you wish then click the little star (add reputation) at the bottom end corner of my post.
Another option:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks