putting two functions together

C

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.
 
J

Joel

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

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