Excel macroFollow

You can do it with the TRIM to character with wildcards function, or the LEFT, MID and RIGHT functions if the number of characters is static. For example, you have cell A with what, 48 characters of data you want removed. You want to keep what is on the left, so you would use =LEFT(A1 , 48) if you want the middle, you would use MID(A1, 34, 48) where 34 and 48 are number of characters before and after what you want to keep.

You can get fancy with the trim and left functions and combine them with IF statements to process text before or after a specific character. such as the example below that just kills any text in the cell if it has a # or a * in it.
=IF(OR(LEFT(A2,1)="*",LEFT(A2,1)="#"),MID(A2,2,LEN(A2)),A2)

You can also use MID to a specific character. For example:
=MID(A1,FIND(" ",A1)+1,255)
would nuke up to 255 characters before or after a space in the text. instead of a space you could use
=MID(A1,FIND("^",A1)+1,255)
Those types of functions should allow you to drag populate them throughout your sheet. Keep in mind the more functions you have in a workbook, the slower it loads and runs.

highlight the rows or columns you want to remove, (use Shift + click to select first row or column, scroll to end, and select last if you want) then select the drop down on the "delete" button in office 2010 and hit delete row or delete column respectivly. Screenshots if needed. http://www.addictivetips.com/windows-tips/how-to-delete-remove-blank-rows-columns-in-excel-2010-spreadsheet/

In that case just select the crap out of the colums or rows by using mouse click on the letters or numbers and shift, and then hit either delete or cut. I forget which.

Thanks a bunch! That looks like it will work, and I'll try it when I go into work next.