Search results 116

Sorted from new to old.

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

2020Aug16

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

2020Feb1

RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

2019Dec18

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

2019Aug9

1 2 ...4 ...7 8