ok here is what im trying to do in my excel sheet i have 157 rows and in column E some cells are occupied with a name the others are blank i would like to find a formula that would say if the cell in column E has a name in it add the word "and" to it with a space after "and" i would like it to do the whole column any help would be greatly appreciated thanks new to this

Jeff