Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • Last Modified:

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".
0
hermesalpha
Asked:
hermesalpha
  • 2
1 Solution
 
Rob HensonIT & Database AssistantCommented:
="Automatiskt justerad BTK: "&C8&" "&C9
0
 
Rob HensonIT & Database AssistantCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now