View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DB--less than excel expert
 
Posts: n/a
Default How can I remove an indent within a cell?

How can I remove an indent within a cell? For example, I have a column of
data that has several different indents some with no indent. How do I remove
all of the indents? When I look at the formula for cells with indents, I see
=' XYZ5

My data appears in the column as follows

XYZ5
XYZ4
XYZ3
XYZ2

I would like all of the data to be left justified w/o having to manually go
in and delete the ' from the cells.

Many thanks,
DB