H
huijbens
Dear Excel Power Users,
I have a problem with copy of formated text to another sheet.
Cell contains multiple fonts and sizes but copies only the first
font and size as format for the whole contents
example: Sheet1!A1 : mahIgGABEI (a=alpha) (ABEI=superscript)
using the " =A1 " function in for example Sheet2:
Sheet2!A1=Sheet1!A1 becomes mahIgGABEI (all normal Arial)
using Copy&Paste works fine ! Can this be solved using a function
instead of Copy&Paste specific cells to other sheets by hand, I
cannot vindt the function doing what Copy&Paste does.
I've found the following info concerning this problem on:
http://www.jegsworks.com/Lessons/numbers/format/formatcells.htm.
seebelow - but are still unable to solve it, please help!
Richard Huijbens
(e-mail address removed)
Attachment: User Defined Function for Copy&Paste?.doc
EXTRA INFO:
A format that is applied to a selected cell is applied to all of the
characters in the cell. Some formats can be applied to just
some of the characters in a cell, if you are in Edit mode.
Copy Formatting: To copy formatting you can use the
Format Painter or the Paste Special command.
Format Painter:
The Format Painter button works much as it does in Word.
The biggest difference is that Excel's Format Painter works only
on the cell as a whole. You cannot use it on just part of the
text in a cell. In fact, it is grayed out when you are in Edit mode.
When you click the button, the pointer changes to its Format
Painter shape. Click on a cell or drag across several cells to
apply the copied formatting. The pointer then returns to its
Select shape. To use Format Painter to format several cells that
are not next to each other, double-click the Format Painter button.
The pointer will remain as its Format Painter shape until you click
the button again. If a cell contains more than one format for text,
such as different font sizes, Format Painter will copy only the first
formatting that it finds
I have a problem with copy of formated text to another sheet.
Cell contains multiple fonts and sizes but copies only the first
font and size as format for the whole contents
example: Sheet1!A1 : mahIgGABEI (a=alpha) (ABEI=superscript)
using the " =A1 " function in for example Sheet2:
Sheet2!A1=Sheet1!A1 becomes mahIgGABEI (all normal Arial)
using Copy&Paste works fine ! Can this be solved using a function
instead of Copy&Paste specific cells to other sheets by hand, I
cannot vindt the function doing what Copy&Paste does.
I've found the following info concerning this problem on:
http://www.jegsworks.com/Lessons/numbers/format/formatcells.htm.
seebelow - but are still unable to solve it, please help!
Richard Huijbens
(e-mail address removed)
Attachment: User Defined Function for Copy&Paste?.doc
EXTRA INFO:
A format that is applied to a selected cell is applied to all of the
characters in the cell. Some formats can be applied to just
some of the characters in a cell, if you are in Edit mode.
Copy Formatting: To copy formatting you can use the
Format Painter or the Paste Special command.
Format Painter:
The Format Painter button works much as it does in Word.
The biggest difference is that Excel's Format Painter works only
on the cell as a whole. You cannot use it on just part of the
text in a cell. In fact, it is grayed out when you are in Edit mode.
When you click the button, the pointer changes to its Format
Painter shape. Click on a cell or drag across several cells to
apply the copied formatting. The pointer then returns to its
Select shape. To use Format Painter to format several cells that
are not next to each other, double-click the Format Painter button.
The pointer will remain as its Format Painter shape until you click
the button again. If a cell contains more than one format for text,
such as different font sizes, Format Painter will copy only the first
formatting that it finds