Thread: finding a number within a text and numbers for multiple rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darshan Darshan is offline
external usenet poster
  
Posts: 12
Default finding a number within a text and numbers for multiple rows
i have the following text in

A1 Darshan_4875_09
A2 Jack_4888_09
A3 Johansson_8988_09
A4 AB_9900_09

I need to get in column B only the numbers i.e.

B1 4875
B2 4888
B3 8988
B4 9900

How do i get this

Reply With QuoteReply With Quote