excel - I want to delete first characters in a cell and show it in another cell -
i want delete letters before date 20-01-2016
in cell
for eg:-
19-01-2016
not on 20-01-2016
want leave
19-01-2016
half day on 20-01-2016
not feeling well
19-01-2016
chair broken on 20-01-2016
cup of tea
assuming data in separate rows in same column shown in image provided like:
=right(a1,len(a1)-find("20-01-2016",a1)+1)
copied down column b work.
Comments
Post a Comment