I have a spreadsheet with Approx 900 rows of information that has been entered incorrectly.

Spreadsheet has 6 columns.

Contact Name

Contact Number

Company Name

Company Account Number

Order Date

Order Numbers

Every Order should have its own line - However I have approx 900 rows where the order numbers have multiple entries instead of single entries.

All the order numbers end "LO" and there all 8 digits long.

I wanted to know if its possible to use excel to look for all instances of "LO" in the column Order Numbers and delete the original Row and replace it with 3 rows with the same information.

Example:

Attached to this post!

Is this possible? I have 15 historic files each approx 35000 rows and I suspect there are more errors

Spreadsheet has 6 columns.

Contact Name

Contact Number

Company Name

Company Account Number

Order Date

Order Numbers

Every Order should have its own line - However I have approx 900 rows where the order numbers have multiple entries instead of single entries.

All the order numbers end "LO" and there all 8 digits long.

I wanted to know if its possible to use excel to look for all instances of "LO" in the column Order Numbers and delete the original Row and replace it with 3 rows with the same information.

Example:

Attached to this post!

Is this possible? I have 15 historic files each approx 35000 rows and I suspect there are more errors

## Comment