Determining how much space a column uses

sp_spaceused provides information about the space used for text data as index_size:

sp_spaceused blurbs
name            rowtotal  reserved  data    index_size unused 
--------------- --------  --------- ------- ---------- ------ 
blurbs          6         32 KB     2 KB    14 KB      16 KB