Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text using an HTML tage as the identifying place to brea
Hi, I use Excel on a regular basis but more for mailing and website data
purposes, rather than using complex formulae so I'm looking for advice re the best way to go about the following. I need to split the text contained in each cell of one column from a point where the text in the cell is pre-fixed with an HTML tag; for example:- Blah, blah, blah. <strong Blah, blah, blah. So I need the first three blahs in one column and the last three in another. The amount of text is different in each cell, the only identifier of where I need to break the text is the HTML tag. Thanks for anyone's help! C |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text using an HTML tage as the identifying place to brea
=LEFT(A1,FIND("<",A1)-1)
=RIGHT(A1,LEN(A1)-FIND("",A1)) -- David Biddulph "C523" wrote in message ... Hi, I use Excel on a regular basis but more for mailing and website data purposes, rather than using complex formulae so I'm looking for advice re the best way to go about the following. I need to split the text contained in each cell of one column from a point where the text in the cell is pre-fixed with an HTML tag; for example:- Blah, blah, blah. <strong Blah, blah, blah. So I need the first three blahs in one column and the last three in another. The amount of text is different in each cell, the only identifier of where I need to break the text is the HTML tag. Thanks for anyone's help! C |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text using an HTML tage as the identifying place to
Thank you! Will give it a whirl now.
"David Biddulph" wrote: =LEFT(A1,FIND("<",A1)-1) =RIGHT(A1,LEN(A1)-FIND("",A1)) -- David Biddulph "C523" wrote in message ... Hi, I use Excel on a regular basis but more for mailing and website data purposes, rather than using complex formulae so I'm looking for advice re the best way to go about the following. I need to split the text contained in each cell of one column from a point where the text in the cell is pre-fixed with an HTML tag; for example:- Blah, blah, blah. <strong Blah, blah, blah. So I need the first three blahs in one column and the last three in another. The amount of text is different in each cell, the only identifier of where I need to break the text is the HTML tag. Thanks for anyone's help! C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying Last Column With Text | Excel Discussion (Misc queries) | |||
Identifying numbers froma text | Excel Discussion (Misc queries) | |||
identifying text associated with MIN value | Excel Discussion (Misc queries) | |||
Identifying text within a cell | Excel Discussion (Misc queries) | |||
what do I do if a spreadsheet will not allow me to reset page brea | Setting up and Configuration of Excel |