| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Combining cell information
Hi!
I have combined information from different cells on Sheet 1 into one cell on Sheet 2. That works great! But I want to seperate the information in some way - I've tried to change the boldness of the text in the original cells but it doesn't work. Is it at all possible to do this or maybe make a new row after each text information? Thankful for ALL help I can get! |
|
#2
|
|||
|
|||
|
If the combined cells have been formed by using a space or comma or tab or
some other character between the fields, then use Text to Columns... to split the data back up. Ifthe fields are of fixed length, then use LFET or RIGHT to split the data back up. -- Gary's Student "Ann-Charlotte" wrote: Hi! I have combined information from different cells on Sheet 1 into one cell on Sheet 2. That works great! But I want to seperate the information in some way - I've tried to change the boldness of the text in the original cells but it doesn't work. Is it at all possible to do this or maybe make a new row after each text information? Thankful for ALL help I can get! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) | |||
| Combining Information in a Bar Chart | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
