Results 1 to 3 of 3
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Making Excel 2010 accept quotation marks and spaces

    In A1, my text is MyImage.001. In B1, I want to create FLAT "My Image.001 with the " mark and the added space between FLAT and ". So, I used =REPLACE(A1,1,0 "FLAT). No joy. Excel will not add "s, nor will it insert a space. I think that I can nest a SUBSTITUE finction, but I really want to keep this simple. I also want to add a " at the very end, and can do a second =REPLACE for that.

    Find & Replace may work, but I can't figure out how to do it in one step for multiple records A1 is MyImage.001, A2 is MyImage.002, etc. So, for A1, I can Find MyImage.001 and Replace with FLAT "MyImage.001". But how can I select A1..A50 and do one F&R for all? Thanks!
    Last edited by Jimmy-W; 2012-08-25 at 15:08.
    JimmyW
    Helena, MT

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jimmy,

    This works on my copy of Excel 2010, if that is the result you want.
    =CONCATENATE("Flat ",CHAR(34),A1,CHAR(34))
    Concatenation.JPG

    I'm not quite sure why you what the Find and Replace but maybe you can adapt this to what you want if it doesn't fit the bill.
    Last edited by RetiredGeek; 2012-08-25 at 15:21.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks, partner! Now, is there a CHAR or the like with which I can insert a space between FLAT and My... Like FLAT "M

    Figure it out: CHAR(32)
    Last edited by Jimmy-W; 2012-08-25 at 17:21.
    JimmyW
    Helena, MT

Posting Permissions

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