about complex formating in single cell

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
335
Office Version
  1. 2010
Platform
  1. Windows
I've a cell in which some characters are written in bold text and some (after space)written in normal way.
like this hello everybody!
when i copy this cell to other one, it doesn't shows same formating as first one,
it writes as "hello everybody!"
can any one help?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sorry, but I can't replicate that via a 'normal' Copy and Paste. Are you using Paste Special-Paste Values?
 
Upvote 0
what is about the fomula applied when you need to automatically paste that value to other sheet cell?
 
Upvote 0
On 2002-10-06 15:05, Mudface wrote:
Sorry, but I can't replicate that via a 'normal' Copy and Paste. Are you using Paste Special-Paste Values?
Is it possible to use this paste special function by formula?
 
Upvote 0
Sorry, vipulgos, I'm not with you.

How are you 'copying' the mixed format cell to another?

If you just use copy and paste then the format is retained.

If you use copy and paste special-paste values, you will lose the formatting, even if you then use paste special-paste formats.

If you're using a formula to refer to the mixed format cell (eg something like =A1), then again you will not retain the original formatting, even if you then use paste special-paste formats.

Sorry, but the only way to retain the format of the original cell appears to be via a simple copy and paste, everything else seems to destroy the format.

Edit- the above only applies to a mixed format cell, to avoid any confusion.
This message was edited by Mudface on 2002-10-06 15:28
 
Upvote 0
On 2002-10-06 15:26, Mudface wrote:
Sorry, vipulgos, I'm not with you.

How are you 'copying' the mixed format cell to another?

If you just use copy and paste then the format is retained.

If you use copy and paste special-paste values, you will lose the formatting, even if you then use paste special-paste formats.

If you're using a formula to refer to the mixed format cell (eg something like =A1), then again you will not retain the original formatting, even if you then use paste special-paste formats.

Sorry, but the only way to retain the format of the original cell appears to be via a simple copy and paste, everything else seems to destroy the format.

Edit- the above only applies to a mixed format cell, to avoid any confusion.
This message was edited by Mudface on 2002-10-06 15:28
Thanks!
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top