Please, how to find text left from dot? [closed]

asked 2014-02-16 18:25:30 +0100

altair gravatar image

updated 2014-02-16 18:33:39 +0100

Please, if I have expression like:

abc.def.gihj

How can I find text left form dot and right from dot?

I th think I have to COMbINE functions?

Please, is there any tutorial to reccomand?

Sth like: =left ("aaaa.bbb.cccc", search("."; "aaaa.bbb.ccc")) ??? Many thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by altair
close date 2014-02-16 18:46:49.706643