changing numbers in a text string in a new cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xhawk57 - 16 May 2007 17:46 GMT

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?

Reply to this Message

FSt1 - 16 May 2007 17:56 GMT

hi
=SUBSTITUTE(B3,2005,2006,1)
change cell reference to fit your data
Regards
FSt1

> could someone please help me with a formula to change a number (such as a
> date) in a text string in the next cell:
[quoted text clipped - 13 lines]
>
> Is this possible?

Reply to this Message

Gary''s Student - 16 May 2007 17:59 GMT

=SUBSTITUTE(A1,"2005","2006")
Just be sure text wrapping is turned on in the cell with the formula to view
it correctly.

Signature

Gary''s Student - gsnu200722

Reply to this Message

CLR - 16 May 2007 18:04 GMT

=SUBSTITUTE(A1,5,6)

Vaya con Dios,
Chuck, CABGx3

> could someone please help me with a formula to change a number (such as a
> date) in a text string in the next cell:
[quoted text clipped - 13 lines]
>
> Is this possible?

Reply to this Message

Xhawk57 - 16 May 2007 18:22 GMT

Worked like a charm! Thanks a lot!!!

> could someone please help me with a formula to change a number (such as a
> date) in a text string in the next cell:
[quoted text clipped - 13 lines]
>
> Is this possible?

Reply to this Message