Texts + Strings 102 Texts, strings, convert, replace, encode, parts and concatenations

Card image cap
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image cap
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

Frm5.zip

Card image cap
InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

Card image cap
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Card image cap
Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

Card image cap
ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

Card image cap
Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

Card image cap
HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...