Adding a letter before a digit in pre populated cell.

[mdujardin]

Hi Guys,

I have a simple one here, I have rows 1 - 100, I want to put a letter
before each digit.

IE.

OP1
OP2
OP3

How would I go about this without having to do it manually.

Cheers.

 

[Jim Rech]

Select the 3 you entered then grab the fill handle in the lower right corner
and drag it down as far as you want.

--
Jim
| Hi Guys,
|
| I have a simple one here, I have rows 1 - 100, I want to put a letter
| before each digit.
|
| IE.
|
| OP1
| OP2
| OP3
|
| How would I go about this without having to do it manually.
|
| Cheers.

 

[mdujardin]

Yes I had thought of that and then I just found out the data is not
consistent, some of the data is from 1-10, 15-45 etc etc.. That makes
it a little more interesting

 

[Don Guillett]

for each c in selection
c.value="OP"&c
next

 

[mdujardin]

Thanks for that, I've selected my cell range but when I enter this
string in to the Insert Function box it does not accept it. Where do
I need to run it from?

 

[GB]

Thanks for that, I've selected my cell range but when I enter this
string in to the Insert Function box it does not accept it. Where do
I need to run it from?

So I understand this correctly, you have a column of numbers in say column
C, and you want to add OP in front of each number?

In D1 put ="OP" &C1

Copy that down
Then copy the column and paste it on top of the values in col C, using paste
special ... values.


Alternatively, Don's way works too. Goto Tools ... macro... create
However, there's a bit of a learning curve with macros.

 

[Don Guillett]

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm