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

Formula for first three characters
 

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

Formula for first three characters
 

Thanks, Auk, works great

Phil

Formula for first three characters
 

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