How do I remove text which preceeds a number from all data cells in a columb ?
(change "A134.667 " to "134.667" ????)

Hi

Try
EditReplaceFind AReplace with leave blank OK

--
Regards

Roger Govier


"Beaufort 2511" <Beaufort wrote in
message ...
How do I remove text which preceeds a number from all data cells in a
columb ?
(change "A134.667 " to "134.667" ????)

After selecting your data, try,
<Data <TextToColumns <Fixed Width <Next

Click in the preview window to place your "break line" to separate the text
from the numbers,

Then you can click <Finish to get 2 columns ... 1 of text and the other of
numbers,
OR
Click <Next
And with the text column selected by default, click on "Do not import",
Then click <Finish
And you'll remove the text from the original column, leaving the numbers
behind.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Beaufort 2511" <Beaufort wrote in message
...
How do I remove text which preceeds a number from all data cells in a columb
?
(change "A134.667 " to "134.667" ????)

ctrl/shift/enter this, then fill down:
=MID(A1,MATCH(FALSE,ISERROR(1*MID(A1,ROW(1:20),1)) ,0),255)*1
Bob Umlas
Excel MVP

"Beaufort 2511" <Beaufort wrote in message
...
How do I remove text which preceeds a number from all data cells in a
columb ?
(change "A134.667 " to "134.667" ????)