Excel Howto

From Korean Resource Center

Jump to: navigation, search


How to extract columns with information if a DB export has hundreds of columns that are empty
  1. Insert a row below the labels row
  2. =DATAROWS-COUNTBLANK(FULL COLUMN excluding the two top rows)
  3. copy & transpose paste in another spreadsheet
  4. delete the two rows
  5. select empty columns and delete them

=> didn't work in a spreadsheet with 35,000 entries

To use the numeric content of a cell to define the location of another cell within a formula


Last word in Cell

=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))

from http://www.exceltip.com/st/Extract_the_last_word_in_a_cell_in_Microsoft_Excel/368.html

Personal tools