Macro for the following function in excel 2003
I would like to create a macro for the following function:
= Code(mid(E3,1,1)=63
The aim of this macro is to analyse each letter contained in a particular cell. If the code indicates a vowel then a "V" is printed if not then a "C" is printed.
I would like some help with this please.
thanks
Please be more explicit. Your formula, (which you say you want to replace with a macro) only looks at the first character. What result do you expect if there is more than one vowel in the cell.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Yes, that is correct. Actually the function is part of a larger nested function. So if the word under analysis is say "football" then the result should be "CVVCCVCC".
the result will be then be used for further manipulation.
thanks.
Please Login or Register to view this content.
B1 and down: =VC(A1)Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
thanks. this worked nicely.
this function will be used to operate on the maltese language font. there are a few particular letters in the alphabeth such as ġ, ċ, ħ,.
is there a way to include these letters in the function provided above?
regards,
I don't know those characters -- they are not in the ANSI code page (1252) in my version of Excel. Are they Unicode?
hello,
the characters are in Unicode (Hex). These are: 017B, 017C, 010A, 010B, 0120, 0121,
0126 and 0127.
regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks