Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Simple add text to cell, won't work...

    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

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    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

  3. #3
    Join Date
    Mar 2004
    Posts
    6
    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

  4. #4
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    you can paste special... then pick text only.

    That should work

    Michael
    Gotta to do some code

  5. #5
    Join Date
    Mar 2004
    Posts
    6

    Smile

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •