Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a column filled with text (3 letter codes, like 'AFG') I'd like to add the text symbol '#' in front of each code, but leave the text otherwise unchanged. For example: AFG would read #AFG. Is there a way to do this on a selected column?
    Thanks!

  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
    Honu,

    Create a custom Number format like this: 0;0;0;"#"@ then apply that format to the column.
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by RetiredGeek View Post
    Honu,

    Create a custom Number format like this: 0;0;0;"#"@ then apply that format to the column.
    Thanks for the advice!

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    If you actually want the value to have a hash you need to concatenate into another cell, then copy and paste special.
    1. Enter the formula =("~" & A1) in A2.
    2. Highlight A2 and Edit > Copy (or Ctrl C).
    3. Highlight A1 and Edit > Paste Special > Values.
    4. Delete A2.

    cheers, Paul

Posting Permissions

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