Formula ?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
=====================================================



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
 
Back
Top