Trimming merge data to their respective columns removing hypens , dash , asterisk and so o
Hi Guys
See attached file certains columns have data merged in one cell . I need to trim data to their respective columns , however some columns have some garbage like *CHN OR BEL' infront. Expected results are in blue to the right of sheet.
Very tedious need to trim up 4000 lines .a pure head ache .
Need formula to trim these data
Thanking in advance for your kind help
Hey I've attached a sample to you see how can be done ... You need to think and study the 'special' cases for the dots and commas...good luck!
sample prem 2.xlsx
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
Hi Guys
As per annexed file data are both mixed and merge in certain columns that are not allocated to them, need formula to trim data to their respective columns.however some columns have some garbage like *CHN OR BEL' infront. Expected results are in red to the right of sheet.
Very tedious need seriously formula to trim up 1000 lines .
Thanks very much those who can help me
Here's a macro to clean it all up for you:
Please Login or Register to view this content.
Last edited by Olly; 07-16-2014 at 02:30 PM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
As you have replies in both of your threads i'll merge them.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks