ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combining cell information (https://www.excelbanter.com/excel-worksheet-functions/38436-combining-cell-information.html)

Ann-Charlotte

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!


Gary's Student

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