JP wrote:
Is there a hyphen between the numbers and text in each cell? If so,
you can use 'Text to Columns' and specify the hyphen as the delimiter.

1. Select the cells and go to Data menu, Text to Columns
2. Choose 'Delimited' and click Next
3. In the 'Delimiters' box click Other and enter a hyphen in the box.
4. Click Finish.


HTH,
JP

I want it to look like this:

A B
1 001 ROTOR WILL NOT TURN

2 R05C22 TOTAL HUMAN-COMBUSTION



That doesn't produce what the OP wants it to look like.

Alan Beban