I have a column of 50 names
 

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

I have a column of 50 names
 

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

--
Biff
Microsoft Excel MVP


"Skip" wrote in message
...
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

I have a column of 50 names
 

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--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"Skip" wrote in message
...
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


.