software

How do I create a list box within a cell of state abbreviations which i can
then use as a lookup reference for a formula applying tax rates.

I am trying to parse addresses into their basic components (I.E. quot;123 Main
Streetquot; becomes quot;123quot;, quot;Mainquot;, quot;Streetquot;) in an Excel Spreadsheet, for later

Column A has several hundred fixed numbers. Columns B-infinity contains some
of the numbers in column A. I want to sort colums B-infinity so the rows

Hello,

How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.

I am preparing a lengthy list which inlvoves social scurity numbers and would
like to know if I have typed in a duplicate without doing a search each and

Please share whether it is possible to somehow imbed sheet names contained in
a cell to allow for relative referencing in a formula...so autofill can be

I want to lock worksheets for outside users. But when I do it and a macro
needs to go into the worksheet, the system gives an error. So is there a way

Since today I am facing some peculiar change in my excel files. When I

When you have a (large) comment in a cell, and you place the mouse over