Splitting Cells

[silvrwoman]

Is there a way to split multiple cells, not whole columns, at once even when there's rows in between I don't want split? Please see my example photo attached - I want to make the company names (i.e. "Company A, Inc") a separate cell from the project names (i.e. "Project ABC"), but leave all the other cells alone. I have hundreds of these in the spreadsheet and don't want to have to do it manually.

Thanks!

Edit: Sorry - here's an excel version:
Example 2.xlsx

P.S. Please ignore the JPEG, I can't figure out how to remove it.

[Richard Buttrey]

Most probably yes.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Please don't upload pictures. None of us is inclined to recreate your data when you have a workbook available - see guidelines in the Rules area of this forum.

[Marcol]

Insert two columns before Column E
Then in E2

Please Login or Register  to view this content.

And in F2

Please Login or Register  to view this content.

Drag/Fill both Down as required.

Copy Columns E:F and Paste Special > Values to E:F

Then delete Column D

Is that what you need?

[silvrwoman]

Thank you - but I want to just split the Company Name and the Project Name (basically so it would look like just a line between the Company Name and the Project Name) so that the two cells would be a header for the Project Description, but everything else would stay the same (i.e. Description wold not repeat).

It would like kind of like this:
_________________________
Project Name l Company Name
..........Description..........