LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Macro command

I have inherited a file with a column of dates. However, each data
apparently has a blank space in front of it, so it is not recognized as a
real date. Hence I cannot perform algebraic manipulations on them as is.

I need to be able to go to each cell (thousands of them) in these columns
and take out this space on the left. Can someone tell me what the macro
should be to, say, start in cell C8 and edit it and take out the leftmost
character (which is a blank), and then move on to the next row down in that
column. Since some of the rows might be empty, it would be better if we
could just skip those, but it is not necessary.

In case it helps, I believe that all dates are in xx/yy/zz format (with one
spacebar in front).

Thanks!
Dean


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use Macro To Change Which Macro Assigned To Command Button CVinje Excel Discussion (Misc queries) 0 May 25th 10 09:55 PM
Macro command djungst Excel Discussion (Misc queries) 3 November 11th 08 05:01 AM
How to run a macro with the IF command deancarpenter Excel Worksheet Functions 4 July 26th 07 08:32 AM
macro command Param Excel Worksheet Functions 2 February 23rd 06 07:51 AM
macro command Shifting of Multiple Row to the right Excel Discussion (Misc queries) 3 September 15th 05 05:02 AM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"