Solved

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

Posted on 2016-11-28
3
39 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 41903963
="Automatiskt justerad BTK: "&C8&" "&C9
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41903967
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
ID: 41903972
Thanks, this worked fine.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel Date Question 8 46
Cannot locate cell 15 43
Excel not storing numeric string correctly 5 43
Chart to show data in four quadrants 6 23
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
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…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

751 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