Solved

Linking to a cell with different font effects

Posted on 2011-02-27
8
302 Views
Last Modified: 2012-05-11
I am linking cells between worksheets.  The problem is this:
Within some of the source cells I have a different font effect for one of the characters - I am using superscript on one of the characters.  Please see Sheet2 of the attached sample.
When the cell contents are pulled into the destination cell (Sheet1), the superscript effect is lost.  How can I maintain the superscipt text effect?  I need a solution without using VBA.
Thanks for any help. format-within-cell.xlsx
0
Comment
Question by:Dave
8 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
You can't do what you want without VBA. The font style information is not copyable with cell formulas.

Kevin
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 250 total points
Comment Utility
Put another way, you can't apply text formatting to specific characters in a text value that is the result of a formula. And formulas can only affect the cell in which they are located. Therefore it is impossible to copy character specific formatting from one cell to another with formulas.

Kevin
0
 
LVL 6

Expert Comment

by:TinTombStone
Comment Utility
zorvek is right

but how about putting the source values as 1:9.9*10^7 or similar notation
rather than use superscript


0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Why do you need them linked? If it's just for display purposes, you could use linked pictures of the cells if you really need this.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Dave
Comment Utility
Thanks for the input.  It is for display purposes, although I do need to combine the result with the superscript effect with another cell -  In addition to having it appear in a table similar to what is in row 8 on Sheet1, I also need the result combined with another cell in another location of the workbook.  Please see attached screen snip for an example.  Cell A3 is an example of the combined cell I am looking for.  I"m not clear how to link pictures of cells- would I use the Camera tool?


excel-screen-snip.png
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
To use a picture you would use the camera tool. But, that probably defeats the purpose. Just copy the cell to the other destination. You will have to take a snapshot in order to republish it each time you make a change anyway.

Without macros you can't do what you want.

Kevin
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
If you need to combine the results with another cell, you will need code, since you can't format part of the result of a formula. Otherwise the camera tool would be fine, IMO, since it's linked to the source.
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
What Rory means is that the camera tool can be used to create a picture that is dynamically linked to the source cells. Change the source cell formatting in any way and the linked picture is updated to reflect the new formatting.

To use the camera tool to create a picture in 2007 and 2010, you have to add the camera tool to the Quick Access toolbar. Right click on the Quick Access tool bar and select "Customize Quick Access Toolbar..." Find the camera tool and move it to the right list.

To create a picture, select the source cell, click the camera tool, and select the destination.

Kevin
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

772 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

12 Experts available now in Live!

Get 1:1 Help Now