Hi again,

My code is to format a PDF file converted to Excel, therefore needs to
act upon diferent inconsistencies.

I now have a problem that in some conversions my columns are as below

No Time
1 13.30
2P 14.00
3 13.20
4 24.30
5P 09.30

With the P appearing in the same column as the number in a random way.
However sometimes this imports like this;

No Time
1 13.30
2 P 14.00
3 13.20
4 24.30
5 P 09.30

With the P in a seperate column. (The column header from column A is
merged into the header of the P column).

Currently I have to scroll through a lot of data to remove these P
columns and insert the P next to the number. (I have code that moves
all of this data and if causes huge errors and problems if this P is in
a seperate column).

Is there a way I can search for this happening in a sheet and if it has
happened to add the P to the number in the column to the left, then
finally delete all of there P columns?