Phil,
Try =LEFT(R24,3)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Phil Hageman" wrote in message
...
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,
Phil