M
marlea
I am altering REPLACE functions for different parts of my data. Thi
works OK, but it would be more efficient if I could apply one functio
to all of my data.
Data:
Column A
R1 volume measured by...
R4 mass times...
R11 weight is related...
R12 height
R100 distance and time
R124 force
I want to place a colon after the numbers; e.g., R1: volume...; R12
height. If I knew how to find the first occurrence of a space, I thin
I could just find those spaces and replace them with a colon and
space. My work-around is to use REPLACE this way:
I apply this formula to cells with one-digit numbers:
=REPLACE(A1, 3, 1, ": ")
Then I slightly change the formula for cells with two-digit numbers:
=REPLACE(A1, 4, 1, ": ") ... and so on.
Can someone show me a better way of doing this? Thank you
works OK, but it would be more efficient if I could apply one functio
to all of my data.
Data:
Column A
R1 volume measured by...
R4 mass times...
R11 weight is related...
R12 height
R100 distance and time
R124 force
I want to place a colon after the numbers; e.g., R1: volume...; R12
height. If I knew how to find the first occurrence of a space, I thin
I could just find those spaces and replace them with a colon and
space. My work-around is to use REPLACE this way:
I apply this formula to cells with one-digit numbers:
=REPLACE(A1, 3, 1, ": ")
Then I slightly change the formula for cells with two-digit numbers:
=REPLACE(A1, 4, 1, ": ") ... and so on.
Can someone show me a better way of doing this? Thank you