putting two functions together

[Candace]

I am using a function called SpellNumber

=SpellNumber(J28)

.... to automatically enter a dollar amount in words, and it works just fine.
But I want to place two asterisks (**) before and after those words. So I
tried using the CONCATENATE formula

=CONCATENATE(**,=SpellNumber(J28),**)

.... but it am getting an error message saying that this formula is not
formatted correctly. What is wrong with my formatting? Please help.

 

[Mike H]

Try,

="**" &SpellNumber(J28)&"**"

Mike

 

[Joel]

You are missing the double quotes and don't need the 2nd equal sign.

=CONCATENATE("**",SpellNumber(J28),"**")