View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default How to get the number from text?

Get them how (what format)? Put them where (same cell, different cells)?

--
Rick (MVP - Excel)


"JJ" wrote in message
...
I have data as this format: 025BNN, 033WGN, I want to get only the numbers
from the text. how can i do that? thx.