Hello gang! I am looking for a more efficient way of doing this code attached is a copy of the file and its desired result RoOmIE 13-09-18.xlsx
Please Login or Register to view this content.
Hello gang! I am looking for a more efficient way of doing this code attached is a copy of the file and its desired result RoOmIE 13-09-18.xlsx
Please Login or Register to view this content.
Last edited by RoOmIE; 09-18-2013 at 05:15 PM.
notice also that at 10 and 11 there are 8 dots in front of the number also in the code there are some empty cells but i would like there to be just the right amount of cells .. i might need up to 20 columns if not more.. (not likely but it could happen)
Last edited by RoOmIE; 09-18-2013 at 01:24 PM.
What do you mean at 10 and 11 and 8 dots?
There's no data in rows 10 or 11 and the maximum no of dots is 4.
By the way, a quick way to do this would be to insert enough columns and then use Data>Text to columns... with . as the delimter and Treat consecutive delimiters as on unchecked.
If posting code please use code tags, see here.
if you look in my code when there the number is 10 there are 8 dots in in front of it .. the file that i put with 4 dots is an example. When you get to the number 10 the number of dots are reduced to 8. if you wish i could post another example showing you the 8 dots
Please Login or Register to view this content.
RoOmIE 13-09-18-no2.xlsx
here is anoter data file to show you what i mean
Cells containing dots should be selected first.
Please Login or Register to view this content.
Last edited by Fotis1991; 09-18-2013 at 03:51 PM. Reason: Pls use use code tags around your code as per forum rule #3.
this line bugsPlease Login or Register to view this content.
Try
Please Login or Register to view this content.
works again like a charm jindon thanks again!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks