Excel 2003 I want text quoted and then the value of a cell followi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2003 SP2 I need the text '1D8+' followed by the value of a different
cell. I tried Cell Formating but it didn't work.
 
Suppose the value of the different cell is in A1:
="1D8+" & A1
="""1D8+""" & A1
="'1D8+1'" & A1

Example1: text not quoted
Example2: text quoted (double quote). Input: 3 double quotes around 1D8
Example3: text quoted (single quote). Input: Double quote, followed by
single quote before 1D8, then single quote, followed by double quote.

Joerg
 
One way:

="1D8+" & B1

BTW: "didn't work" isn't very informative.


You can also use cell formatting. In the cell, put

=B1

and choose Format/Cells/Number/Custom "1D8+"General
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to values 4
Formula for function/argument "exclude". 0
Can't Copy and Paste in Excel 2003 0
Conditional Formatting in Excel 2007 1
How do I use the text content of a cell as a worksheet reference? 9
Searching the formula (not the value) for a text string 1
Trying to find additional ranges outside of min, max, and average 2
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top