about complex formating in single cell

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
Sorry, but I can't replicate that via a 'normal' Copy and Paste. Are you using Paste Special-Paste Values?
 

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
what is about the fomula applied when you need to automatically paste that value to other sheet cell?
 

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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?
 

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
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
 

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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!
 

Forum statistics

Threads
1,144,766
Messages
5,726,167
Members
422,659
Latest member
RGP268

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
Top