Clear Chevron Characters and Characters Inside Chevrons

[typewriterguy]

Happy New Year, Excel folks.

Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon.

Mouse, Mickey <mickey.mouse@d.com>;

Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).

Thanks.

 

[T. Valko]

Happy New Year, Excel folks.

Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon.

Mouse, Mickey <MICKEY.MOUSE@D.COM>;

Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).

Thanks.

I think your example has been truncated.

Does the string contain a "less than" symbol? If so, put space characters on both sides of it. The forum software interprets the "less than" symbol as a html code character that causes text to be truncated.

 

[typewriterguy]

Happy New Year, Excel folks.

Is there an Excel formula to remove the spacebar + characters in red, as shown below?

I need to be left with only: last name; comma; space between comma an and first name; first name; semicolon.

Mouse, Mickey "<"mickey.mouse@d.com">"<MICKEY.MOUSE@D.COM>;

should look like Mouse, Mickey;

Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).

Thanks.

 

[dave3009]

Mouse, Mickey < mickey.mouse@d.com > ;

You can use spaces to show the gt/lt signs or their html equivalent

 

[T. Valko]

Happy New Year, Excel folks.

Is there an Excel formula to remove the spacebar + characters in red, as shown below?

I need to be left with only: last name; comma; space between comma an and first name; first name; semicolon.

Mouse, Mickey "<"mickey.mouse@d.com">"<MICKEY.MOUSE@D.COM>;

should look like Mouse, Mickey;

Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).

Thanks.

Assuming that the real string does not contain the quotes...

Book1
	A	B
2	Mouse, Mickey ;	Mouse, Mickey;
Sheet2

=LEFT(A2,FIND("<",A2)-2)&";"

 

[dave3009]

=left(A2, find("<", A2)-1)

copied down

 

[Rick Rothstein]

Select your cells (it is alright if you include cells without the "<..>" text in it or blank cells), press CTRL+H to bring up the Replace dialog box. Type this in the "Find what" field...

{space}"< *>"

Do NOT type space after the greater than symbol... it is there for the same reason you needed to put it there... so the symbol shows up. ALSO, do NOT type the "word" {space} as shown, rather type a single space character in for it instead (the text pattern should start with a leading space). Next, click the "Options>>" button and make sure the "Match entire cell contents" checkbox is NOT checked. Now click the "Replace All" button.... the text you want should be remaining.

NOTE: This procedure changes your original data... I wasn't sure if that is what you ultimately wanted or not.

 

[typewriterguy]

Great / helpful answers! thanks!

 

[T. Valko]

Great / helpful answers! thanks!

You're welcome!