Hello,

I am having some problems when I combine two columns of data.

My first column of data is prices : $39.95
My second column is % off : 50%

What I am trying to do is combine the two columns of data so they would read :
$39.95 You save 50%

I am using a formula as follows =C2&"You Save"&D2

When I use this formula the output is 39.5You Save0.5

Now the no spaces between You Save is one thing, I could probably use a find & replace on that and put in some spaces. What is driving me up a damn wall, however, is the removal of $ and changing my % to a decimal. I've tried changing the new column to every column format in the options and nothing changes. Except if I set the column to "text" then the formula stops working.

What's the deal??