i have attached one sheet for your observation.i can do it in text to column command but it will take time and want to do it fast.so i need a vba code for that one can you help me????
i have attached one sheet for your observation.i can do it in text to column command but it will take time and want to do it fast.so i need a vba code for that one can you help me????
Why VBA,
try next formula
=RIGHT(B1,LEN(B1)-4)*1
then Copy paste as needed
- Battle without fear gives no glory - Just try
Else try file attached
if your unmodified data set starts from cell A1 as you posted, try![]()
Please Login or Register to view this content.
I discovered columns orders was not the same, see an update attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks