changing numbers in a text string in a new cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=SUBSTITUTE(A1,"2005","2006")
Just be sure text wrapping is turned on in the cell with the formula to view
it correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Modified By in a cell by user 3
Tax formula tests for multiple filing statuses and income amounts 1
"What-if" formula for either a manual entry and automated entry 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
I need to copy a text value from one worksheet to another 5
text exist 3
Formula to return a value for a portion of a text string in a cell 2
Blank cells 1

Back
Top