Thread: How do I copy numeric section of cell from alpha-numeric cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
  
Posts: 915
Default How do I copy numeric section of cell from alpha-numeric cell[OT]
Harlan Grove wrote:
Now a plug for OpenOffice Calc, which provides simplified regular
expressions. This could be done using

=MID(LEFT(A1;SEARCH("[^0-9]";A1;SEARCH("[0-9]";A1))-1);SEARCH("[0-9]";A1);
255)

[OT]

Harlan,

Yours is the first post I have noticed in this group where OpenOffice
Calc was mentioned. Do you have an article comparing OOC and Excel?
Reply With QuoteReply With Quote