Is there a ATransform or replace command in Excel. i have a value of 04/23/09 which is a date and would like to replace all "/" with "-' thereby making the value 04-23-09. I could examine each character value within a cell but this would just make a long coding and would like to know if there's a shorter way to do this?.
Last edited by teachMeExcel; 05-07-2009 at 10:58 AM. Reason: closing down
If it's ACTUALLY a date, you can simply highlight the entire column of Date values and press CTRL-1 to open the format cells box, select CUSTOM and for the TYPE, enter:
mm-dd-yy
If it's not really a date, if it's text data, then highlight the entire data set, press CTRL-H to open the Search/Replace and fill out the fields appropriately...then REPLACE ALL.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Is 04/23/09 a date? If it were in A1, then =A1+1 should show as the 24th. If not, they it is not a data but a string. In other words, dates are numbers not text strings like 04/23/09.
If it is a numeric format, then a macro could fix your numeric formats for you. If it is a text string, an =Replace() would do the trick.
All, Thanks for the Help. It works like wonders in Macro. Problem SOLVED.
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks