Thread: seperate the character and number in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom taol tom taol is offline
external usenet poster
  
Posts: 52
Default seperate the character and number in formula


A1 : dfg56Yt - B1 : dfgYt - C1 : 56
A2 : 549pp - B2 : pp - C2 : 549

I want to make above.
using only excel embedded function, not UDF.
namely in column B, only character
namely in column C, only number

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote