| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 @? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 @? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 @? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 @? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Symbol or text after number to used in sum | Excel Worksheet Functions | |||
| Symbol after text | Excel Discussion (Misc queries) | |||
| extracting after a symbol | Excel Discussion (Misc queries) | |||
| Add the inches symbol after text | Excel Discussion (Misc queries) | |||
| Need to align text around a symbol??? | Excel Worksheet Functions | |||
Hybrid Mode
