Posted to microsoft.public.excel.programming
|
|
Add spaces to cell
Works great,thanks
philcud wrote:
using functions not vb
if names in column a
formula in b1
=LEFT(A1&" ",17)
this adds 17 spaces to the name, then returns the left 17 characters of
this new string.
|