Solved

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

Posted on 2016-11-28
3
9 Views
Last Modified: 2016-11-28
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
Comment
Question by:hermesalpha
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
Rob Henson earned 500 total points
Comment Utility
="Automatiskt justerad BTK: "&C8&" "&C9
0
 
LVL 31

Expert Comment

by:Rob Henson
Comment Utility
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
 

Author Closing Comment

by:hermesalpha
Comment Utility
Thanks, this worked fine.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Checkbox Notification 3 23
+1 to an even value 4 11
Formula to convert ranked data 2 9
MIN, using ARRAY 4 0
What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now