Determine 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