Excel extract 2

[sabetik]

Is there a function in the EXCEL to reterive just portion of the test. Ex;

salesmanager@test.com. just need to extract all words before the "@". salesmanager.

Thanks
kamran

 

[SkipVought]

hi,

If the value is in A1
[tt]
=LEFT(A1,FIND("@",A1)-1)
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[petrosky]

Hi kamran,

If your data is in column A...you could use something like this in column B.

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

HTH.

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[petrosky]

Nice one Skip!

Remember- It's nice to be important,
but it's important to be nice

 

[KenWright]

Or Data / Text to Columns / delimited / Other and put an @ sign in the 'Other' field. Then just choose not to import the second column. That way it is all done in situ with no need for helper columns.

Regards
Ken.........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------