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

[Plohish]

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.

[g_erhard]

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 ]

[Plohish]

Thank you for your help. It worked just fine!

[Jack in the UK]

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