View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default deleting characters from beginning of call

Hi,
Let' say the column with blank is column A in another column enter

=trim(A1)

copy formula down, then do copy, go to column A, paste as values

"fazz" wrote:

Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.