| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding text between 2 @ signs
I have the folling in a cell:
SD09071707444004362@Micki Caldwell@20090716115600 I want to remove the text between the 2 @ signs. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text between 2 @ signs
Micki wrote:
I have the folling in a cell: SD09071707444004362@Micki Caldwell@20090716115600 I want to remove the text between the 2 @ signs. Thank you =LEFT(A1,FIND("@",A1)-1)& MID(A1,FIND("@",A1,FIND("@",A1)+1)+1,LEN(A1)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text between 2 @ signs
Hi,
Try this with your string in a1 =MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,"@",CHAR(7),1)) +1,FIND(CHAR(7),SUBSTITUTE(A1,"@",CHAR(7),2))-FIND(CHAR(7),SUBSTITUTE(A1,"@",CHAR(7),1))-1) Mike "Micki" wrote: I have the folling in a cell: SD09071707444004362@Micki Caldwell@20090716115600 I want to remove the text between the 2 @ signs. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text between 2 @ signs
=TRIM(MID(SUBSTITUTE(A1,"@",REPT(" ",99)),99,99))
"Micki" wrote: I have the folling in a cell: SD09071707444004362@Micki Caldwell@20090716115600 I want to remove the text between the 2 @ signs. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my text appear as pound signs | Excel Discussion (Misc queries) | |||
| Excel 07 - text displays as pound signs | New Users to Excel | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Pound (#) signs instead of text | Excel Discussion (Misc queries) | |||
| Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Hybrid Mode
