Hi,
I have in column A of improper company name. I need to be make in a proper proper format. I have attached the test file of it. Please check the attachment.
Hi,
I have in column A of improper company name. I need to be make in a proper proper format. I have attached the test file of it. Please check the attachment.
Did anyone got the solution?
Hi
sorry but i cannot make sense of what you require?
could you explain please?
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
I need all the multiple companies to be in one format.
Example:-
Column A has a company
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corp
Lions Gate Entertainment Corp
Lions Gate Entertainment Corp
Lions Gate Entertainment
here some of the companies has full form and some of the companies are having half.
I need to make all these in to one form like
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corporation
Lions Gate Entertainment Corporation
Which I had showed in column B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks