and close that up and there you go and now well because it’s in a formula what we need to do is copy this and paste it right over here and now you can see that is a general this is something that we can use as a string and let’s just check it just to make sure we’re gonna do right we’re gonna do this one let’s do all of them and we’ll do four and there you go so now it works that is what we are looking for um and you can do that imagine doing that with millions of rows or you know let’s say 10 000 rows it’s gonna be a breeze right it’s going to take you two minutes or a minute to do everything that you want to do instead of having to just do a bunch of mess to convert it to a string which i promise you i’ve done and it just takes forever it’s it’s terrible so that is date to text super helpful formula let’s go over to trim now Trim