Delete part of a cell

[Francis]

I have a spreadsheet with 10,000 rows with this information;
Rows look like this,

R1 Ontime: 100.00%
R2 711 *OEM1676EN
R3 Tot
R4 Ontime: 92.00%
R5 129 D317002

I need to find all rows that contain "Ontime:" and remove the word "Ontime:"
to leave the percentage in that cell only. This is all in one column. Or, can
I just copy the percentage part to another cell?
Please help

 

[Don Guillett]

try selecting the column header>edit>replace>Ontime:, leave blank

 

[CLR]

Data > TextToColumns > using a colon as the delimiter, will place the
percentages in the next column to the right...........if that's a help

Vaya con Dios,
Chuck, CABGx3

 

[Gary''s Student]

Select the cells and then:

Edit > Replace
replacewhat: Ontime:
leave replacewith blank

 

[Don Guillett]

You may like this even better
Sub replacewords()
Set rng = Range("d8:d12")
rng.Replace "Ontime:", ""
For Each c In rng
c.Value = Right(c, Len(c) - 3)
Next
End Sub

 

[Francis]

that worked, thank you very much

Select the cells and then:

Edit > Replace
replacewhat: Ontime:
leave replacewith blank