adrian123
03-26-2019, 07:48 AM
Hi All,
I am looking for macro to delete all lines in excel based on data stored in column A.
In column A I have data in the following format:
/text1/text2/text3/text4/text5/text6
/text1/text2/text3/text4/text5
/tex1
/text1/text2
/text1/text2/text3
I have to delete all lines in excel where there is data after 3 rd /, so the result after deletion should be:
/text1
/text1/text2
/text1/text2/text3
text in each case can be different lenght but deletion should be always after 3 rd / keeping text3
Thank you for helping me
I am looking for macro to delete all lines in excel based on data stored in column A.
In column A I have data in the following format:
/text1/text2/text3/text4/text5/text6
/text1/text2/text3/text4/text5
/tex1
/text1/text2
/text1/text2/text3
I have to delete all lines in excel where there is data after 3 rd /, so the result after deletion should be:
/text1
/text1/text2
/text1/text2/text3
text in each case can be different lenght but deletion should be always after 3 rd / keeping text3
Thank you for helping me