putting two functions together

  • Thread starter Thread starter Candace
  • Start date Start date
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.
 
You are missing the double quotes and don't need the 2nd equal sign.

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