Solved

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

Posted on 2016-11-28
3
20 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 32

Accepted Solution

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to open excel in 2016 is slow 4 21
Boolean help 6 27
Add a range in an Excel graph 5 35
MS Excel IF AND OR statement 3 27
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 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

24 Experts available now in Live!

Get 1:1 Help Now