hi guys, I import data in the form of a column of names, they come with a country suffix eg/ John Doe (GB), I need to add the names to a table without the suffix. at the minute I am doing this manually, and its slow, what is the best way to speed this up.
have you tried find and replace? Find (*) and replace - leave blank. Worked in my test file.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try this formula
=REPLACE(A1,FIND("(",A1)-1,255,"")
John Doe (GB) John Doe
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
This will also work. The TRIM will remove any unneeded spaces.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Or simply this.....
Assuming your name is in A1 then
Please Login or Register to view this content.
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.
Gentlemen you are all superstars I thank you one and all
You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks