Hi,
I've been pulling my hair out here, hope someone can help..

I want to add (prefix) text to a lg column of numbers as such:
manco_ added to # i.e.

1234-10 (to be) manco_1234-10
1234-20 (to be) manco_1234-20

so basically add a prefix of a mfg name in front of the model number (that has dash's in the model #).

I tried (and tried) to format the cell as Custom: "manco_" 0 or even "manco_" #
Does not work!, unless I retype the number back into the cell does the prefix take effect and I can't do that with this lg column.

PLEASE SOMEONE HLP!!
Many pre thanks... KJ

In another column, in the first cell type this:

="manco_"&A1

Replace A1 with whatever the cell is that has your information to be modified. After you see that this is providing you the right information, fill this data down to all of the other cells below it. Now, copy that whole column, and go to the column that has your original information and do a Paste Special and select Values. Now go back to the column that you had previously entered the formula in and delete it, since it will now say manco_manco_1234-10.

TD

Hey thank you very much TD...

Your a lifesaver, it works perfectly!
On a related note... (since you soud like you know MS Ex really well)
How can I paste in a table of html in a cell without it getting all jumbled up (links all go together w/ reg text etc.)

Thank you!!!!

KJ

you can paste special... then pick text only.

That should work

Michael

Thanks Michael, I'll give it a try !
~Ken