View Single Post
  #1   Report Post  
no_junk_mail
 
Posts: n/a
Default Copy a cell value and add literals

I'm trying to use a function to take the value of cell (B3 contains
"08/31/2005", for example) and copy it to another cell (G3, for example),
and add a preceeding and trailing asterisk = I tried typing the following
=("*"(B3)"*") into the formula bar while the cursor was in cell G3 - but all
I ended up with in G3 was - "*"(B3)"*" - I'm sure that this is an easy one
for someone - I'd appreciate any suggestions - THANKS!