Formula to split text string

[lindseya66]

Hello,

I have values that are pulling in from my data set as "Name-Email". I would like to only keep the Name. Is there a formula I can use to get rid of the - Email part?

 

[etaf]

you can extract to a different cell - if you want the cell to be modified then it will need VBA

as you have 365 , then a textbefore()

=TEXTBEFORE(A2,"-")

Book3
	A	B
1
2	name-email	name
Sheet1

Cell Formulas
Range	Formula
B2	B2	=TEXTBEFORE(A2,"-")

 

[lindseya66]

Thank You!! you just made my day! worked perfect!

 

[etaf]

you are welcome