| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining text and numbers in a string | Excel Worksheet Functions | |||
| extracting numbers within text string! | Excel Worksheet Functions | |||
| EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
| Incorporating Numbers into a text string | Excel Worksheet Functions | |||
| Changing a specific character type in text string | Excel Discussion (Misc queries) | |||
Threaded Mode
