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.

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.