View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rajesh Rajesh is offline
external usenet poster
 
Posts: 47
Default extracting substring

Hi,

Please find the follwoing data
abcd efg [R51K]
abc efg[R52E]
abcd efghij [R31K]

From this i need the data without [Rxxx].

please suggest how to do this
Thanks