Thread: Splitting a text string into string and number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Splitting a text string into string and number
A formula like =sum(right((a1:a4),1)*1)) is an *array* formula.
Double-click on the cell to edit. Instead of Enter press
Shift+Ctrl+Enter.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote