Thread: Pull Out Numbers From String
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curious[_6_] Curious[_6_] is offline
external usenet poster
  
Posts: 22
Default Pull Out Numbers From String
This column is comment. Numbers mixed with text in the cells. They
look like

Statue of liberty 12345 statue of liberty
12345 statue of liberty statue of liberty
statue of liberty statue of liberty 12345

The number (product order code) could be anywhere.

How do I pull out the numbers by formula or by VB code?

Thanks in advance.

HZ

Reply With QuoteReply With Quote