Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to automate the process to add 2 ** before and after the

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How to automate the process to add 2 ** before and after the content in the cell?

    I have a list of over 950 entries in my spreadsheet every week. In order for the content to be properly displayed on the webpage I have to add 2 ** before and after the ticker symbol.

    I.e. Cell B1: AOL has to be **AOL**.
    Cell B2: CCBL has to be **CCBL**

    What is the easiest and fastest way to do it?

    Thank you in advance.

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    San Ramon CA
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What I'd do is create a custom format if all that's needed is to adjust the way data is displayed. If you need to actually get the ** bits into the data, then I'd use the string concatenate operator as part of the formula.

    ="**" & stringdata & "**"


    Using this formula, if stringdata = "AOL" then the result is "**AOL**". That should accomplish what you need.

    [ This Message was edited by: g_erhard on 2002-04-22 12:15 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you for your help. It worked just fine!

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I.e. Cell B1: AOL has to be **AOL**.
    Cell B2: CCBL has to be **CCBL

    In A1 Type AOL
    In B2 type :

    ="**" &
    $A1 &
    "**."


    looks odd just copy and paste in B1 and will be fine, drag as needed

    I have made it look odd so asy to understand:

    WARNING.

    Select B1 hit F2 and paste else will bounce into B1:B3, not so good must to allocated in full to ONE cell/

    Hope this is OK



    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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