replace text

[Chad]

1) Can you make a macro that searches for text and then replace that text
with other text?
2) If so, can you make this macro look for several different text and
replace them all with the same text?
3) Can you make a formula that shows the current month in the following
format: January, February, March, April, May…
4) Can you make a macro that replaces parts of a file name in the reference
portion of a formula?

 

[Max]

My guess for this Q

3) Can you make a formula that shows the current month in the following
format: January, February, March, April, May…

In any cell: =TEXT(TODAY(),"mmmm")

If above helped in some way, high-five this response, click the YES button
below

P/s: Ask only 1 specific question per thread. Make it attractive for
responders to respond. Post in .progamming for questions involving macros.
That's where the vba savvy responders live, breathe n hang out.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---