Search results 60

Sorted from new to old.

ShapeDelete

Safely remove certain shape from worksheet

Sep30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

May16

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

1 2 3 4