Hello,
I'm searching for a VBA that can help me Concatenate 2 columns and then find and replace "DALLAS MANUFACTURING COMPANY" to "GOOGLE and then remove any duplicate values. Finally I want to seperate text and number to have text in one column and number in seperate column. Please see the attached. Thank you.
Test.xlsx
without VBA
see the result.
1) CTRL + H
find DALLAS MANUFACTURING COMPANY
replace by google
2) make a header on the sheets
3) make a table of your data
4) insert the formula in D2
5) Data => remove duplicates on colum D
6) you could delete column D (or hide column D) afterwards.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
BTW, your method did not seperate text and number after remove duplication
Thanks for response. I need a macro to do it because it belongs to one of my master sheet and it needs automation to complete when assign to speacific buyers. Could you help me then?
Record the actions above with the macro-recorder and you get the code you need.
And for your post #4.
In column B there is tekst.
In column C there is a number.
I think this is what your asked for.
As already said, you can delete column D (if you want).
Last edited by oeldere; 07-15-2013 at 03:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks