Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
How would the code look if you wanted to exclude certain alpha characters like "I", "O" or "Q" etc... from your function output?
easier to enter A in cell A1 and then in B1 type =SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),4),1,"") and drag down
Thanks a million for your input.
Thank youuuuu
You're most welcome. Please subscribe and be with us.
Thank you!
You are most welcome
Superb
Thank you! Cheers!
Thanks ✍️
Most welcome. Please subscribe and be with us.
Whenever i try this i get a value error. Any suggestion?
Use the number one (1) in your VBA code instead of the lowercase L.
@@JordanGoh-oj1hz this didn't work. I'm getting VALUE error too.
Where I find the VBA code?
Link is in the video description
Please share excel sheet of above formula, ready made
Check description
@@Excel10tutorialneed excel sheet.plz share
Thank you so much Sir
How would the code look if you wanted to exclude certain alpha characters like "I", "O" or "Q" etc... from your function output?
easier to enter A in cell A1 and then in B1 type =SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),4),1,"") and drag down
Thanks a million for your input.
Thank youuuuu
You're most welcome. Please subscribe and be with us.
Thank you!
You are most welcome
Superb
Thank you! Cheers!
Thanks ✍️
Most welcome. Please subscribe and be with us.
Whenever i try this i get a value error. Any suggestion?
Use the number one (1) in your VBA code instead of the lowercase L.
@@JordanGoh-oj1hz this didn't work. I'm getting VALUE error too.
Where I find the VBA code?
Link is in the video description
Please share excel sheet of above formula, ready made
Check description
@@Excel10tutorialneed excel sheet.plz share
Thank you so much Sir
You're most welcome. Please subscribe and be with us.