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