Creating fixed information in a cell
Can anyone help me figure out how to keep a "fixed" word in a cell but add
information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
Creating fixed information in a cell
Hi Kay,
="From: "&a2 assuming the date is in A2 hth regards from Brazil Marcelo "Kay" escreveu: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
Creating fixed information in a cell
Use a custom format like this
"From:" @ when you type in something like "test" in the cell it will look like this Form: test "Kay" wrote: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
Creating fixed information in a cell
If you want to use a different cell:
="From: " & text(a1,"mm/dd/yyyy") If you want to use the same cell, give it a custom format of: "From: " mm/dd/yyyy The nice thing about the second choice is that the value in the cell is still a date--even though you see "From: " in the cell in the worksheet (but not in the formula bar!). Kay wrote: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! -- Dave Peterson |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com