Copy a cell value and add literals

[no_junk_mail]

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!

 

[JE McGimpsey]

One way:

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

 

[Gord Dibben]

Try this in G3

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

Adjust format to your liking in the formula.


Gord Dibben Excel MVP