i have a project where it has a set of letters a to z in three columns A, B , C ranging from 1 to 18000 and i need to delete all of the "y" s in the columns and move over to the left (or up in order) those letters after y to replace the blank spot. for example the original set is :
A B C
1 y x a
2 a y d
3 a b c
4 y x z
and needs to change to :
A B C
1 x a
2 a d
3 a b c
4 x z
do you no of any formula that could satisfy that in excel??
A B C
1 y x a
2 a y d
3 a b c
4 y x z
and needs to change to :
A B C
1 x a
2 a d
3 a b c
4 x z
do you no of any formula that could satisfy that in excel??
