Anyone know a link to a good Excel help site or is anyone gracious enough to lend me their intelligence?

- Basically, I've got a few rows of data (say, five). I need to eliminate the first 4 rows of data (but only in one column) and keep the last one. The last one is all I need. I have a bunch of entries where this is the case so I need a formula or function that can take the first entries out and leave the last one. (the entries are a combination of numbers, semicolons, and "#" symbols)

- For this last entry, I need to figure out a way to omit the last 2 characters which are ";#"


I'm an Excel n00b if you can't already tell.

 

I'm sure I could write some VBScript you could use in a macro to do what you want, but I'm not sure what you want.

When discussing things Excel, saying "row" is all columns of one row; saying "column" is all rows of one column; anything else would be expressed as a range in spreadsheet notation like C1-C4 (the first four cells of the third column)

Now with that explanation, you say you want to eliminate the first four rows only in one column. Do you mean the the whole row or the cells in the column? If you mean row, do you mean delete the row (slide the lower rows up) or blank out the row?

I'm going to assume a couple of things. If this was a one-off spreadsheet, you would just delete the cells (or rows) and move on, but since you're asking for a macro to do this, you must have many of these files you need to do this on.

That makes me think that you're dealing with some sort of export from another program, probably text based. Maybe it'd be easier to edit the file in notepad before opening it in Excel?

 

Yeah, you're right on saying there's a lot of files. I used an "IF" statement to trim the un-needed cells(ty for the correction) so that's finished, but the thing I need to do now is to trim each of those filtered cells by exactly the last 2 characters.

 

edit: I found a delete function which can specify how many characters and from which part of the cell you want to delete.

 

Another case of me over-engineering a solution....