Forum Discussion
Ubaid ur Rahman
Apr 03, 2018Brass Contributor
How to fill multiple cell one after another in one column refer to adjacent cell
In the table below you will see values so you can easily understand what I am asking for! This is what I have and which have no pattern in cells!
I want this as seen in the table...
- Apr 03, 2018
Hi
Use combined IF and LEN functions
=IF(LEN(B2)=9,A1,B2) ect
Tomasz Kocur
Apr 03, 2018Brass Contributor
Hi
Use combined IF and LEN functions
=IF(LEN(B2)=9,A1,B2) ect
Ubaid ur Rahman
Apr 03, 2018Brass Contributor
Wow! thanks alottttt!!!!!