In one column i have:
Suite 4, Level 13 97 Creek Street BRISBANE
202 Boundary Street SPRING HILL
Level 2 303 Adelaide Street BRISBANE
Level 21 345 Queen Street BRISBANE
In the column beside it i have:
BRISBANE
SPRING HILL
BRISBANE
BRISBANE
I am looking for a way to delete the words in capitals at the end. Sometimes it is 2 words.
It would be great if i could simply deduct the second column text from the first column.
Thoughts?
you can use find and replace, just copy in the word like BRISBANE to the find, then in replace leave blank.
hit replace all and they're gone.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi
in C2
=Substitute(A2,B2,"")
Should do the trick: after that copy paste special values on column A.
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
The problem is they arent all BRISBANE.. there are hundreds of different names
Thanks. Going to try this nowOriginally Posted by canapone
Worked like a charm! Thank you
Hi,
thanks for your very kind feedback.
If you copy your text into Word this command in the Find and Replace will remove all uppercase words.
Enable wildcards
Find What: [A-Z]{2,}
Replace With: nothing
Replace all.
<---------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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks