Delete part of a cell
 

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

Delete part of a cell
 

try selecting the column headereditreplaceOntime:, leave blank
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Francis" wrote in message
...
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

Delete part of a cell
 

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



"Francis" wrote:

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

Delete part of a cell
 

Select the cells and then:

Edit Replace
replacewhat: Ontime:
leave replacewith blank
--
Gary''s Student - gsnu200767


"Francis" wrote:

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

Delete part of a cell
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Francis" wrote in message
...
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

Delete part of a cell
 

that worked, thank you very much

"Gary''s Student" wrote:

Select the cells and then:

Edit Replace
replacewhat: Ontime:
leave replacewith blank
--
Gary''s Student - gsnu200767


"Francis" wrote:

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