How/can I automatically prefix what is already typed in a cell?

  • Thread starter Thread starter trc310
  • Start date Start date
T

trc310

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.
 
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
 
Back
Top