>>998184i tried it in VBA:
open VBA by pressing Alt+F11
open a new module by going to Insert > Module
copy and paste the following code
Function OUTPUT(x) As String
Select Case x
Case Is = "A", "a", "E", "e", "I", "i", "O", "o", "U", "u"
OUTPUT = "Vowel"
Case Is = "Y", "y"
OUTPUT = "Both"
Case Is = BLANK
OUTPUT = BLANK
Case Else
OUTPUT = "Consonant"
End Select
End Function
and then will have a working function is named OUTPUT
go back to excel, click a cell and enter something like =OUTPUT(D2)
