Thread: How do i strip off Upper case Characters to another cell in Excel.
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do i strip off Upper case Characters to another cell in Excel.
Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html

then use this formula
=REGEX.SUBSTITUTE(A1,"[^A-Z]","")


"gugertmk" wrote:

example "Myers Power Products" in cell A3 end result "MPP" in cell C6
Reply With QuoteReply With Quote