Thread: Remove number from text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adunao adunao is offline
external usenet poster
  
Posts: 1
Default Remove number from text string
Please how do I remove numbers from unformatted texts strings e.g
DEPOSIT RICA MARINE 6890312 RICA MARINE
or
DEPOSIT 7048783 KURUS NIG
or
DEPOSIT 7042248 NNAJI 7042248 NNAJI
Pls I need a plobal formula for these
Reply With QuoteReply With Quote