Hi,
My name is Gracie. I'm new to the forum.
I use Office 2003... As shown in my attachment, I would like to delete duplicated text in multiple rows. I use to know how to do this but it's not coming to mind. I don't want to have to do this, row-by-row, as this file has 4806 rows. My attachment is a screenshot of my file, to show you all, for example purposes-only. I would like to delete data, starting from the dot, to the last name. How do I do this? In advance, thank-you for your help.
Gracie
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi GracieTeu,
Welcome to the Forum.
Attach a sample workbook not an image. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
You can simply use Find and Replace...
Try Replacing ".*" with Nothing ie "" (without quotes.)
that should do...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks