ExcelBanter - extracting text around the @ symbol

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - extracting text around the @ symbol (https://www.excelbanter.com/excel-worksheet-functions/147522-extracting-text-around-%40-symbol.html)

KFB

extracting text around the @ symbol

I have been sent multiple pieces of data all in one field. How can I extract
the text surrounding the @?

Gary''s Student

extracting text around the @ symbol

You can use Text to Columns to separate the data into individual cells using
the @ as a separator.
--
Gary''s Student - gsnu200732

"KFB" wrote:

I have been sent multiple pieces of data all in one field. How can I extract
the text surrounding the @?

Mike H

extracting text around the @ symbol

Try,

=LEFT(A1,(FIND("@",A1,1)-1))&MID(A1,FIND("@",A1,1)+1,999)

Mike

"KFB" wrote:

I have been sent multiple pieces of data all in one field. How can I extract
the text surrounding the @?

Teethless mama

extracting text around the @ symbol

=SUBSTITUTE(A1,"@","")

"KFB" wrote:

I have been sent multiple pieces of data all in one field. How can I extract
the text surrounding the @?

All times are GMT +1. The time now is 10:27 AM.