Search results 86

Sorted from new to old.

NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Feb1

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Remove Managed by Your Organization from Edge

AI helped me here to remove the message on my browser of (Managed by your ...

Jan10

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

1 2 ...5 6