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

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

Thanks, Auk, works great

Phil

YW Phil and thanks for your reaction.
It's always nice to hear that a suggestion was usefull.

--
Regards,
Auk Ales

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

"Phil Hageman" wrote in message
...
Thanks, Auk, works great.

Phil