In Excel 2007, how do I insert a blank space between two dynamic values in a cell?

I followed the advice on this website for inserting a dynamic value together with static text in a cell:

http://spreadsheetpage.com/index.php/tip/display_text_and_a_value_in_one_cell/

(I used the ampersand method.)

So my formula in P32 looks like this now:

="Automatiskt justerad BTK: "&C8

But how do I make it like this?:

="Automatiskt justerad BTK: "&C8 &C9

So that the contents in C8 is displayed dynamically together with a blanks space and the contents in C9 displayed dynamically.

I managed to get it to work with a blank space in another place when I used this formula:

=C8&" "&C9

Above formula displays correctly "1640 auto".
LVL 1
hermesalphaAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
="Automatiskt justerad BTK: "&C8&" "&C9
0
 
Rob HensonFinance AnalystCommented:
If C8 or C9 are numeric or dates, you will get the raw value of the cell so it may look strange. If you want the numerical value formatted to a particular format you can use the TEXT function:

=TEXT(number,"format")

Examples
=TEXT(C8,"£0.00") will format the value in C8 as currency with 2 decimals

=TEXT(C8,"dd/mm/yy") will format C8 as a date in European format.
0
 
hermesalphaAuthor Commented:
Thanks, this worked fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.