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!

One way:

=TEXT(B3,"\*mm/dd/yyyy\*")

In article ,
"no_junk_mail" wrote:

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!

Try this in G3

="*"&TEXT(B3,"mmmm d" &"," &"yyyy")&"*"

Adjust format to your liking in the formula.


Gord Dibben Excel MVP



On Tue, 6 Sep 2005 16:12:17 -0500, "no_junk_mail"
wrote:

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!