![]() |
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! |
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! |
All times are GMT +1. The time now is 12:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com