Hello Friendz,
Need Vba to convert Cell values with fixed format as shown in file.. Please assist as to how can I do this.. thank you
Hello Friendz,
Need Vba to convert Cell values with fixed format as shown in file.. Please assist as to how can I do this.. thank you
Last edited by Parth007; 03-23-2016 at 08:39 AM.
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
Can this be achieved with formula or VBA will do for this.. please assist
Please Login or Register to view this content.
Simply Superb Great work.. thank you so much Jindon.... it actually saved my time.. total rows were 5000+
Please Login or Register to view this content.
Hi Jindon.. I see there are one more data difference..
Input-
1) ATS REX 2) BIP TI 3) CAT TOE
Xas Tgu, Yie TT, Z R
Ouptup Should be -
Input-
1) ATS REX
2) BIP TI
3) CAT TOE
1)Xas Tgu,
2)Yie TT,
3)Z R
Please assist for both values
You should upload a workbook with all the possible combination data and the result that you want.
Hi Jindon... in all data the above was one unique which I missed to specify in file....
Your code covered everything except this which I missed
I went through all data..
Hi Jindon.. Please see the file with all possible combinations...
Last edited by Parth007; 03-23-2016 at 08:38 AM.
For the data provided.
Please Login or Register to view this content.
Bang Bang... that's was more than perfect one... thank a lot Jindon !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks