extracting data

J

John

I saved a note pad document into a excel document. All the fields are in
column A. The data is a mix of text and numbers. i.e. gas bottle pressure
100.
The spaces between pressure and 100 come from the note pad document. How do
I export just the number into another sheet?

Totally lost,
JOHN
 
R

Rowan Drummond

Select the data in column A and then from the menus use Data>Text To
Columns to get the pressure into it's own column. Probably choose
Delimited on the first screen and Space on the second.

Hope this helps
Rowan
 
J

John

Great, Thanks. However, Rowan I need to go from here to selecting the data.
Now that the data are in columns I need to extract specific data. Here's the
kicker. The data I am searching for doesn't always fall on the same row. How
do I search/look or find the data then put it in a sperate column? Thanks
kindly

JOHN
 
Top