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

  2. Categories
  3. Texts + Strings
Card image cap
NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21
Card image cap
IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24
Card image cap
IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24
Card image cap
Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22
Card image cap
ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1
Card image cap
LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30
Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23
Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6
Card image cap
Filename_Clean

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

2023Jan11
Card image cap
MultiTrim

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

2022Dec3
Card image cap
ANStr2Range

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

2022Nov11
Card image cap
HyperlinkFunction

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

2022Aug24