Formula for first three characters

[Guest]

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

 

[A.W.J. Ales]

Phil,
Try =LEFT(R24,3)

--
Regards,
Auk Ales

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

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.

 

[Guest]

Thanks, Auk, works great

Phil

 

[A.W.J. Ales]

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 *