Thread: Formula for first three characters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
  
Posts: 160
Default Formula for first three characters
In worksheet cell R24 (merged cells R24:T24), is a number in the following format: 1.1.3; 2.3.1; 4.3.2; etc

In cell N22 (merged cells N22:O22) I want to put the first three characters of the R24 entry. In the above examples, the response would be: 1.1, or 2.3, or 4.3

What would the formula be

Thanks
Phi

Reply With QuoteReply With Quote