Get exact duplicate of text from another cell (Bold on and off etc.)

  • Thread starter Thread starter Mike B
  • Start date Start date
M

Mike B

If, for example, A1 contains the text 'Michael'. The
capital 'M' is in Font Color (red) and Bold. Can you have
a formula like B1=A1 whereby 'Michael' will appear in B1
with the same character 'M' in Bold and Red?

TIA

Mike
 
Hi Mike,
Excel formulas (as well as UDFs) are not capable to copy format
information. They only copy text/values

Frank
 
Frank,
Thank's for the reply,

Mike
-----Original Message-----
Hi Mike,
Excel formulas (as well as UDFs) are not capable to copy format
information. They only copy text/values

Frank




.
Click to expand...
 
If, for example, A1 contains the text 'Michael'. The
capital 'M' is in Font Color (red) and Bold. Can you have
a formula like B1=A1 whereby 'Michael' will appear in B1
with the same character 'M' in Bold and Red?
Click to expand...

Not with formulas, but you could paste picture links. Copy A1, move to B1, hold
down the [Shift] key and click on Edit in the menu bar. The Edit menu should
include a Paste Picture Link entry.

If you'd also need cell B1 to evaluate to what's in cell A1, you could also
enter the formula =A1 in cell B1 and give B1 the number format ;;; .
 
-----Original Message-----
If, for example, A1 contains the text 'Michael'. The
capital 'M' is in Font Color (red) and Bold. Can you have
a formula like B1=A1 whereby 'Michael' will appear in B1
with the same character 'M' in Bold and Red?
Click to expand...

Not with formulas, but you could paste picture links. Copy A1, move to B1, hold
down the [Shift] key and click on Edit in the menu bar. The Edit menu should
include a Paste Picture Link entry.

If you'd also need cell B1 to evaluate to what's in cell A1, you could also
enter the formula =A1 in cell B1 and give B1 the number format ;;; .
Click to expand...
I actually wanted to use it in a modification of Stephen
Bullen's scrolling data list using the formula =OFFSET
(H7,$B$14,0,1,1). Column H would contain an alphabetically
sorted list and to make it easier to find an entry when
scrolling this range, the first A***, B***, C*** etc.
entry in column H would be highlighted as per Michael
above.
Mike.
 
Back
Top