I have imported a bunch of data into excel, however, the data I have has a
bunch of extra characters at the end that I don't need. Can I write a Macro
to delete a set number of characters off of each cell that I run the macro on?
I have imported a bunch of data into excel, however, the data I have has a
bunch of extra characters at the end that I don't need. Can I write a Macro
to delete a set number of characters off of each cell that I run the macro on?
This is the key code:
a = Replace(ActiveCell.Value, "s", "")
the rest is up to you!
Best regards,
Ray
you dont necessarily need a macro .Post a sample of what the dates look like
now what you want them to look like
--
paul
[email protected]
remove nospam for email addy!
"T-Dot" wrote:
> I have imported a bunch of data into excel, however, the data I have has a
> bunch of extra characters at the end that I don't need. Can I write a Macro
> to delete a set number of characters off of each cell that I run the macro on?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks