Texts + Strings 165

Texts, strings, convert, replace, encode, parts and concatenations

Sorted from new to old.

Filename_Clean

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

2023Jan11

MultiTrim

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

2022Dec3

ANStr2Range

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

2022Nov11

HyperlinkFunction

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

2022Aug24

Range2ANStr

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

2022Jul19

Frm5Textbox

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

2022Feb22

InStr and InStrRev

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

2021Dec6

Special chars

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

2021Oct13

Morse code functions

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

2021Jun13

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

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

2021Jun9

Navigate_IE

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

2021May31

HTMLTagAttributeValue

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

2021May30

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

1 2 ...5 ...10 11