| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically prefix cell entry
Hi,
I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically prefix cell entry
Use a custom format of
"ABC"# This will only change how the cell is displayed, not the cell value. The cell will display as ABC123 (in your example), but when you click on the cell you will notice the value of the cell is only 123. "rossinvrland" wrote: Hi, I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically prefix cell entry
Thanks, Sloth! It works like a charm! And it's as easy as I hoped it might be.
"Sloth" wrote: Use a custom format of "ABC"# This will only change how the cell is displayed, not the cell value. The cell will display as ABC123 (in your example), but when you click on the cell you will notice the value of the cell is only 123. "rossinvrland" wrote: Hi, I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically prefix cell entry
Try a custom format of:
"ABC"General -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "rossinvrland" wrote in message ... Hi, I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically prefix cell entry
On Thu, 4 Jan 2007 08:54:00 -0800, rossinvrland
wrote: Hi, I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross Format/Cells/Number/Custom Type: "ABC"General For General you can substitute any valid number format. --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically prefix cell entry
THANKS TO ALL! :-)
"Ron Rosenfeld" wrote: On Thu, 4 Jan 2007 08:54:00 -0800, rossinvrland wrote: Hi, I'm looking to have a function or format or macro to take a user entry into a cell and then automatically prefix that entry and display the result. For example, if the prefix is set to ABC & the user enters 123 in cell A1, then as soon as the user goes to another cell, then A1 will display ABC123. I tried CONCATENATE, but that doesn't do quite what I am looking for because it keeps changing every time the worksheet is refreshed. There's got to be something simple to make a function out of a simple 'find & replace' task. Thanks in advance! Ross Format/Cells/Number/Custom Type: "ABC"General For General you can substitute any valid number format. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| automatically add borders to a cell after entry is complete | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
