Formula for first three characters

P

Phil Hageman

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

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 *

Phil Hageman said:
In worksheet cell R24 (merged cells R24:T24), is a number in the following
Click to expand...
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
Click to expand...
characters of the R24 entry. In the above examples, the response would be:
1.1, or 2.3, or 4.3.
 
A

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 *
 
Top