View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Elegant Formulas

littleredhairedgirl wrote:[i]
I use Notepad++ that allows a more clear (elegant) way to edit/
visualize script like this

function changeImages() {
if (document.images) {
for (var i=0; i<changeImages.arguments.length; i+=2) {
document[changeImages.arguments].src = eval
(changeImages.arguments[i+1] + ".src");
}
}
}
// END --

If I have a excel formula like
=ISNUMBER(FIND(LEFT(B2,1), "AWFUY"))



I can use ALT-Enter to place breaks in the cell to allow
=ISNUMBER(
FIND(
LEFT(B2,1), "AWFUY")
)


Anyone know of a editor that knows Excel?


FWIW I sometimes debug Excel formulae using the SQL language editor in
Notepad++. It does not recognize most Excel keywords but it nicely
parses parentheses, text, and such.

N++ will let you create your own keyword lists if you are so inclined.