Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple cells (3) adding a Colon (:)
Hi,
I have 3 columns with 500 rows. I would like to combine 3 cells horrizontally into 1 cell adding a colon (:) between each combined cell. At the same time is it possible to indicate the first colon to be bold and the rest normal? I appreciate your response. Thank you -- smile |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple cells (3) adding a Colon (:)
=A1&":"&B1&":"&C1
Copy down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "israel" wrote in message ... Hi, I have 3 columns with 500 rows. I would like to combine 3 cells horrizontally into 1 cell adding a colon (:) between each combined cell. At the same time is it possible to indicate the first colon to be bold and the rest normal? I appreciate your response. Thank you -- smile |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple cells (3) adding a Colon (:)
Say be begin with data in columns A & B & C.
In D1 enter: =A1 & ":" & B1 & ":" & C1 then copy column D and PasteSpecial Values onto itself. FOrmatting a sinlge character can either be done manually or with a macro. -- Gary''s Student - gsnu200856 "israel" wrote: Hi, I have 3 columns with 500 rows. I would like to combine 3 cells horrizontally into 1 cell adding a colon (:) between each combined cell. At the same time is it possible to indicate the first colon to be bold and the rest normal? I appreciate your response. Thank you -- smile |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple cells (3) adding a Colon (:)
Hi,
You really can't format part of a formula, so if you follow GS's suggestion of converting to values you will be able to format the first colon, however, with 500 of these I would do it with code, not manually. Here's some sample code, to run it you select the range where you converted the formulas to value and run it... Sub FormatColon() Dim X As Integer Dim cell As Range For Each cell In Selection X = InStr(1, cell, ":") cell.Characters(X, 1).Font.Bold = True Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "israel" wrote: Hi, I have 3 columns with 500 rows. I would like to combine 3 cells horrizontally into 1 cell adding a colon (:) between each combined cell. At the same time is it possible to indicate the first colon to be bold and the rest normal? I appreciate your response. Thank you -- smile |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple cells (3) adding a Colon (:)
I did follow GS's instruction and it worked well combining the cells with a
colon, what you are suggesting is a bit more than I manage. If it won't be much of a bother I would ask you to indicate from step 1 where and how to insert the code. In matter of fact once I combined the cells, cell A1 & B1 which is designed to be bold, turned normal in the combined cell. If you can help me with this it would be greatly appreciated. Thank you, Thank you -- smile "Shane Devenshire" wrote: Hi, You really can't format part of a formula, so if you follow GS's suggestion of converting to values you will be able to format the first colon, however, with 500 of these I would do it with code, not manually. Here's some sample code, to run it you select the range where you converted the formulas to value and run it... Sub FormatColon() Dim X As Integer Dim cell As Range For Each cell In Selection X = InStr(1, cell, ":") cell.Characters(X, 1).Font.Bold = True Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "israel" wrote: Hi, I have 3 columns with 500 rows. I would like to combine 3 cells horrizontally into 1 cell adding a colon (:) between each combined cell. At the same time is it possible to indicate the first colon to be bold and the rest normal? I appreciate your response. Thank you -- smile |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a colon to military time | Excel Worksheet Functions | |||
how to change colon to semi-colon in CP/List Seprator | Excel Discussion (Misc queries) | |||
Need to combine multiple cells into on cell | Excel Worksheet Functions | |||
combine text of multiple cells | Excel Worksheet Functions | |||
How can I combine multiple cells in Excel? | Excel Discussion (Misc queries) |