Home » Forums » Open Source Learning Center » Question and Answer

isWord() ?

Submitted by laks on 29 May, 2009 - 19:42

Hi, I am trying to do a quick tool to get palidromes. I need a function that will verify if a word is a real word. There is isText or isNumeric, but if there a isWord , which would return true for a valid word like 'table' and false for 'tebal'.

 

Is there something like that?

AttachmentSize
dictionary.txt2.38 MB
Dictionary.xlsm2.9 MB
‹ How to find out (or cancel) what's scheduled with OnTime() AnalyzerXL? ›
»
Nick's picture

isword

Submitted by Nick on 29 May, 2009 - 20:08.

nop, but you can write one yourself pretty easily

Steps:

  • download a dictionary
  • store it on a sheet, or read it in on opening
  • Write IsWord in VBA.. a couple of lines
»

Download a dictionary?

Submitted by laks on 29 May, 2009 - 20:20.

Download a Dict? Sounds a bit extreme? :) Any suggestions?

»
Nick's picture

dictionary

Submitted by Nick on 29 May, 2009 - 21:02.

added one to your post... and an Excel file with a working IsWord function.

; - >

»

palindromes

Submitted by laks on 29 May, 2009 - 21:19.

Thanks. There were 108 palindromes in that list. (str = reverStr(str)

»