about complex formating in single cell

vipulgos

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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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
331
Office Version
  1. 2010
Platform
  1. Windows
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
331
Office Version
  1. 2010
Platform
  1. Windows
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
331
Office Version
  1. 2010
Platform
  1. Windows
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,181,531
Messages
5,930,432
Members
436,738
Latest member
JFry

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