kelly mort
Wellknown Member
 Joined
 Apr 10, 2017
 Messages
 1,796
 Office Version

 2016
 Platform

 Windows
I have in column D strings like
A1B1C1D1E1 or A5B1C3D1E4 etc
There can be blanks too. There length will always be even if not blank.
Which means we can have from 2 characters up to 10 characters.
So from the above given example if cell D2 is having A5B1C3D1E4, then I am splitting it and filling from I2 to M2 with
5, 1, 3, 1, 4
Then we repeat that to last used row in D.
So if length of the string is not up to 10, then the remaining cells in col I to M is filled with blank.
I hope this is possible .
Thanks in advance
A1B1C1D1E1 or A5B1C3D1E4 etc
There can be blanks too. There length will always be even if not blank.
Which means we can have from 2 characters up to 10 characters.
So from the above given example if cell D2 is having A5B1C3D1E4, then I am splitting it and filling from I2 to M2 with
5, 1, 3, 1, 4
Then we repeat that to last used row in D.
So if length of the string is not up to 10, then the remaining cells in col I to M is filled with blank.
I hope this is possible .
Thanks in advance