| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format column to link file names in that column | Excel Discussion (Misc queries) | |||
| Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
| How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
| Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
![Skip[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
