Cell lookup to point in cell

[Digi]

Good day Guys and Girls,

I find myself in need of a little help if you'd be so kind.

I suspect it probably requires a query thats as long as hell, BUT, what I want to do in a excell worksheet (mainly because im getting tired of guessing) is for example

CELL A1 = DBMSSQL.DOMAINA.COM

in cell B2 i want to have
B2 = DBMSSQL

the formula without something like =LEFT(A2,7) i would like it to search for the . and do the left till there.

Thanks in advance for any help you guys can give me here.

 

[Aladin Akyurek]

Good day Guys and Girls,

I find myself in need of a little help if you'd be so kind.

I suspect it probably requires a query thats as long as hell, BUT, what I want to do in a excell worksheet (mainly because im getting tired of guessing) is for example

CELL A1 = DBMSSQL.DOMAINA.COM

in cell B2 i want to have
B2 = DBMSSQL

the formula without something like =LEFT(A2,7) i would like it to search for the . and do the left till there.

Thanks in advance for any help you guys can give me here.

Try...

=LEFT(A1,FIND(".",A1)-1)

 

[Digi]

OMW your joking.

well shows you when you try think way to much you miss the simple answers.

Thanks Aladin, most appreciated.

 

[Aladin Akyurek]

OMW your joking.

well shows you when you try think way to much you miss the simple answers.

Thanks Aladin, most appreciated.

You are welcome. Thanks for providing feedback.

 

[Digi]

Cell lookup to point in cell [RESOLVED]

Just a note for anyone that looks for something like this.

this methode will work for just about anything.

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-2)

Example (A1 has values, B1 has formula)
A1 = (10.0.0.1)
B1 = 10.0.0.1

the Right will be the same.

New Motto for Life
K.I.S.S. = KEEP.IT.SIMPLE.STUPID.