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

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.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prefixing a number to the number in a cell 2
adding the same prefix or suffix to a range of cells 5
update a word as a prefix in a column for all rows. 2
How can I select the largest number in a list... 1
How do i append a number with "000" 6
Adding a prefix to all numbers in a column. 1
Inserting additional data into a cell 4
How can I add a two letter prefix to text in cells? 2

Top