New answers tagged

1

The regex /$[0-9\s]+/ attempts to match numbers and whitespace immediately after the end of line. That will never match anything. Use /[\s\d]+$/ to match numbers and whitespace immediately before the end of line. You apparently to want to add numbering to the end of headings. The split() and if seem unnecessary and can probably be removed. Simply use this: ...


0

If you have a date in A2 then =text(A2,"ddd") would give "Mon", "Tue", "Wed", etc. =text(A2,"dddd") would give "Monday", "Tuesday", "Wednesday", etc.


Top 50 recent answers are included