View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 340
Default Ho to remove spaces before values?

Select column then DataText to ColumnsFixed WidthNext.
Remove any lines then click Finish

On 9 Mar, 11:39, Lion2004 wrote:
Hi!
I have document with different values and some of them has spaces before
value. Text was imported into excel!
Is it possible somehow remove automatically all spaces from the beginnng of
the all cells?
Thank you!

Peter