200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have used the code on this website to extract a word from any cell (Get_Word)and for some reasons the function doens't show up for selection. I cannot figure out why not. Thanks!
Function Get_Word(input_data, delimiter, word)
word = word - 1
input_data = Split(input_data, delimiter)
Get_Word = input_data(word)
End Function
Hi Adi and welcome to the Forum
I believe you are referring to the code from Don's tutorial Simple Excel Function to Extract a Word or Text from a Cell (which next time you can add to your question using the "Add Link" button).
Not sure what you mean by "the function doesn't show up for selection". Provided you have added the code as a Module, if you enter a cell in any sheet of that workbook and type just "=Ge" several functions should be offered by autocomplete (dependent on your version of Excel), incuding "Get_Word".
Bear in mind that there's no help provided with the function (so you need to rememeber how to enter the parameters)
