I want to develop a code to take an affirmative statment (eg: Sam cleans the room.) and give a negative statement as an output (eg: Sam did not clean the room.)
I was initially thinking of using the Split function to split the first word and add “did not”/”has not”/”is not”, but that will become too tedious. Besides verb also needs to change accordingly (Eg: cleans –> clean)
So, is there a way to do it? Is there an inbuilt Excel function that I can use?