I have a column of 50 names

S

Skip

some are bold and some underlined. Later in the worksheet I want the
names to appear in another column.
I tried =A1 and copied down, but I only got the name, but not the bold
or underline.. Is there a formula I can use, or do I need the copy/
paste the column to where I want it. Thanks in advance for your help.
Skip
 
T

T. Valko

Formulas can only return values to a cell. They can not return any
formatting. Copy/pasting will bring the format along with the data.
 
R

ryguy7272

Copying/Pasting is the only thing that's going to bring those formats over.
Typing the '=' sign and then entering a formula definitely won't give results
with formats.

HTH,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
MS Project Center-Autolink column fields 0
Excel - Wich Function should I use? 1
Excel help needed: Skipping cell without skipping cell reference 1
How to paste this down? 3
format the following paragraph beneath found text 0
Using font elements as condition criteria 2
I have a column of 50 numbers 5

Top