Cell Formatting

Hello all,

I have cells with 2 data types in them; date and text.
The date is the first 5 characters of the cell as a serial number and then the following is alt enters and text.
Is there a way to format this cell to show the serial number as day and the remaining text as text?
Bear in mind that I refer to these cells to obtain the serial number for other formatting.

Thanks in advance,

Matt

Ok, this is definitely a step in the right direction as to what I was looking for, so thanks for that!

The output is not using the same alt enters to place the data on the same lines as before, basically eliminating them. Also it doesn't seem to go through the whole cells data because if you add another alt enter and line of text it gets left out of the format. I added an ActiveCell.ClearFormats at the beginning of this macro so that it could be reran for testing but that wipes all other formats that have been applied so it would be good to have it clear this format first then go through to apply it, that way it could be reran on pages where I will be updating info.

Thanks for any further help,

Matt

Aweosme progress!

The only thing still not working is the multiple lines of text after "Hello World" which I have had to add to validate and confirm they are indeed being dropped likely from the way the array is grabbing the cell data. Would MID grab the first 5 and then MID to LAST grab the rest properly?

I know just enough to be dangerous

OK, so I finally am wrapping my head around how your code is working, so if I add another & Chr(10) & ary(2) to the end of s3 AND there is an extra line it will then add that data to the output, but again leave off any other lines. I think I need a statement to count the ary()'s and add the extra statements as needed through a loop or case statement.

Thanks again!

Wow, Brilliant

Join() much better solution than I could have come up with lol

Thanks again for all your help!