Hi, I try to reduce or remove empty space in each cell of string variables because it really hinders me from eyeballing the dataset, using the following code: https://www.statalist.org/forums/for...tching-purpose.

However, it turns out that most cells still take too much space before its values. Could there be any possible solution? Thank you.

Code:
local varlist firmid ksic4 firmname         
foreach v of varlist `r(varlist)'{
   local vformat: format `v'
   local vformat: subinstr local format "%" "%-"
   format `vformat' `v'
}