How to extract text between <>

		Microsoft Office Forums > Microsoft Excel > Excel
How to extract text between <>

02-06-2018, 11:32 PM

macropod

Windows 7 64bit How to extract text between <>

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

=mid(a1,search("<",a1)+1,search(">",a1)-search("<",a1)-1)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
I'm looking for a formula to extract all the text before the last name in a cell	Gef	Excel	4	02-01-2015 07:14 PM
Is there a way to extract various text in Word?	barnkeeper410	Word	4	07-08-2013 10:58 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.