position characters

I don't know if my solution will require a macro or not. I can use macros, but don't know how to write them. At any rate, here's my scenario: I've got nearly 3800 rows of part numbers and I need to only see/use the ones that have a 1 at the 8th position. All part numbers are 14 characters long...

I'm putting together a macro in Excel 2007 (Windows XP) to paste some data in a cell range that feeds a graph. Is there a vba code that will change what cell is selected one column to the right (Example: Current selected-cell is A9 -- there is already data in this cell-- I would like to...

I'm putting together a macro in Excel 2007 (Windows XP) to paste some data in a cell range that feeds a graph. Is there a vba code that will change what cell is selected one column to the right (Example: Current Selected cell is A9, I would like the selected cell to be one to the right, or...

<TABLE style="WIDTH: 710pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=942><COLGROUP><COL style="WIDTH: 172pt; mso-width-source: userset; mso-width-alt: 8374" width=229><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH...

Hey, I have a question if I have a column like the following John Smith Jacob Crosby (Leader) Doug Johnson Is there any combinations of functions which will allow me to find the position of the character of the last name for all names? For instance I've used functions but they give me the...