Try the attached workbook.
The sheet [Lookup] is used to map which letters / combinations relate to Consonants (C) or Vowels (V).
The user-defined-function then loops through all these rows, and replaces the actual letter(s) with a C or V appropriately, for the string provided.
So, you can use =CVStructure("irishword") to translate it into the CV style word structure.
Hope this makes sense!
Last edited by Olly; 10-21-2013 at 08:52 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks