changing numbers in a text string in a new cell
Worked like a charm! Thanks a lot!!!
"Xhawk57" wrote:
could someone please help me with a formula to change a number (such as a
date) in a text string in the next cell:
for example:
in column A I have data that reads:
2005 tax returns (Alt - Enter)
2005 Financial Statements
and in cell be I need a formula the will take that information and make it
say:
2006 tax returns (Alt-Enter)
2006 financial Statements
The text will not always be the same as you go down the colum but i want to
carry it over in a large spreadsheet while updating the date.
Is this possible?
|