putting two functions together
 

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.

putting two functions together
 

Try,

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

Mike

"Candace" wrote:

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.

putting two functions together
 

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

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


"Candace" wrote:

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.