Excel vba programming question?

The following text is in a cell: WILLIAMS PIPELINE PRESSURE 890 # I would like to extract 890 from the text and place it in a cell on another report. How do I do this with Excel VBA? I cut it and pasted it using a macro but, the macro just hard codes 890 and even if my customer changes it to, say, 900 the next... show more The following text is in a cell:
WILLIAMS PIPELINE PRESSURE 890 #
I would like to extract 890 from the text and place it in a cell on another report.
How do I do this with Excel VBA? I cut it and pasted it using a macro but, the macro just hard codes 890 and even if my customer changes it to, say, 900 the next day, my program still picks up the hard coded 890.

Thanks,....
3 answers 3