| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How/can I automatically prefix what is already typed in a cell?
I need to prefix some numbers with an index, such as 111,. The numbers are
already written in. I want to add the prefix for all the numbers (1250). All the numbers are in A1 thru A1250. Is this possible? Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How/can I automatically prefix what is already typed in a cell?
In B1 use this formula..
=VALUE("111"&A1) Drag this down...Once done select Col B and copy --paste special--values... If this post helps click Yes --------------- Jacob Skaria "trc310" wrote: I need to prefix some numbers with an index, such as 111,. The numbers are already written in. I want to add the prefix for all the numbers (1250). All the numbers are in A1 thru A1250. Is this possible? Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically add a prefix to cell value in Excel? | Excel Discussion (Misc queries) | |||
| automatically prefix cell entry with leading zeros | Excel Worksheet Functions | |||
| Automatically prefix cell entry | Excel Worksheet Functions | |||
| Can numbers be typed to automatically be negative in cells? | New Users to Excel | |||
| Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
Linear Mode
