Spreadsheet: 787555d1657864828-remove-characters-between-two-symbols-and-more-with-formula-forum_upload_characters_2
Sheet: Sheet1

Original text | [NAME] test | Example output | Formula from Bo_Ry
Myall Creek Wattle is known&nbsp;from two populations near Delungra and [NAME]. Each population occupies less than 5 hectares. Individuals on&nbsp; Kirramingly&nbsp;Nature Reserve have been&nbsp;described as a separate subspecies <span style="font-style: [NAME]>subsp.<span style="font-style: italic"> planitiicola (</span>formerly<span style="font-style: italic"> planiticola)</span>,of which six small patches exist.&nbsp;The distribution, ecology&nbsp;and failure of each subspecies to form seed pods suggests the species was once very widely distributed in the region. |  | Myall Creek Wattle is known from two populations near Delungra and [NAME]. Each population occupies less than 5 hectares. Individuals on Kirramingly Nature Reserve have been described as a separate subspecies [NAME] atrox subsp. [NAME] (formerly planiticola),of which six small patches exist.The distribution, ecology and failure of each subspecies to form seed pods suggests the species was once very widely distributed in the region.
May require regular fire to maintain populations. Too-infrequent fire may lead to population decline, particularly if the fire interval is greater than 20 years.;1|Usually grows in wet heath and acid swamp areas and along watercourses on granite, above 900 m altitude.;2|Associated species include <em>Baeckea omissa, [NAME] microphylla, [NAME] sieberi, [NAME] and <em>Restio</em> species.;3|Flowers from September to November.  The species does not spread vegetatively and is probably an obligate seeder.;4 |  | May require regular fire to maintain populations. Too-infrequent fire may lead to population decline, particularly if the fire interval is greater than 20 years. Usually grows in wet heath and acid swamp areas and along watercourses on granite, above 900 m altitude. Associated species include [NAME], [NAME] microphylla, [NAME] sieberi, [NAME] and Restio species. Flowers from September to November. The species does not spread vegetatively and is probably an obligate seeder.
The <em>Acacia loderi</em> Shrublands are known from the Broken Hill Complex, Murray-Darling Depression, Cobar Peneplain, Riverina, [NAME] and Darling Riverine Plains Bioregions. Sites occur from south-western NSW to north-western Victoria and eastern South Australia. In NSW, the community is mainly confined to south-western NSW, extending east to Hillston and north to White Cliffs. The major stands occur between Broken Hill, Ivanhoe and Wilcannia, while isolated stands occur beyond these areas. |  | The Acacia loderi Shrublands are known from the Broken Hill Complex, Murray-Darling Depression, Cobar Peneplain, Riverina, [NAME] and Darling Riverine Plains Bioregions. Sites occur from south-western NSW to north-western Victoria and eastern South Australia. In NSW, the community is mainly confined to south-western NSW, extending east to Hillston and north to White Cliffs. The major stands occur between Broken Hill, Ivanhoe and Wilcannia, while isolated stands occur beyond these areas.
[NAME] occurs primarily in Bolivia Hill Nature Reserve south of Tenterfield. The population was estimated at&nbsp;1000 mature plants in 1999, reportedly&nbsp;decreasing&nbsp;during the subsequent decade. However, new sub-populations were discovered with more extensive field work, including one very large patch. The drought of 2018-2019 led to severe grazing by macropods and a major reduction in mature plants. Subsequent rains have stimulated seedlings but competition with&nbsp;<span style="font-style: italic;">Boronia anethifolia</span>, which was not as greatly reduced by grazing, may hinder a return to prior abundance in some patches. A previous record near Demon Nature Reserve has been subsequently identified as <span style="font-style: italic;">Boronia granitica</span>. |  | [NAME] occurs primarily in Bolivia Hill Nature Reserve south of Tenterfield. The population was estimated at 1000 mature plants in 1999, reportedly decreasing during the subsequent decade. However, new sub-populations were discovered with more extensive field work, including one very large patch. The drought of 2018-2019 led to severe grazing by macropods and a major reduction in mature plants. Subsequent rains have stimulated seedlings but competition with Boronia anethifolia, which was not as greatly reduced by grazing, may hinder a return to prior abundance in some patches. A previous record near Demon Nature Reserve has been subsequently identified as Boronia granitica.
<span style="font-style: italic;">Boronia hapalophylla</span> is known from eight localities between Chambigne Nature Reserve and Sherwood Nature Reserve where it is locally abundant in Yuraygir State Conservation Area and Sherwood Nature Reserve. |  | Boronia hapalophylla is known from eight localities between Chambigne Nature Reserve and Sherwood Nature Reserve where it is locally abundant in Yuraygir State Conservation Area and Sherwood Nature Reserve.
<em>Caladenia arenaria</em> is found mostly on the south west plains and western south west slopes. The original description is of a plant from Nangus, west of Gundagai (1865) and there is a report of the species from [NAME] near Tumut. A record near Cootamundra needs verifying. The Sand-hill [NAME] is currently only known to occur in the Riverina between Urana and [NAME]. |  | Caladenia arenaria is found mostly on the south west plains and western south west slopes. The original description is of a plant from Nangus, west of Gundagai (1865) and there is a report of the species from [NAME] near Tumut. A record near Cootamundra needs verifying. The Sand-hill [NAME] is currently only known to occur in the Riverina between Urana and [NAME].
Usually grows in sand along watercourses in shrubland and open woodland in granite country; it also occurs in drier sites, including exposed ridges.;1|Plants are naturally killed by flood-waters, but seed germinates readily and mature plants are quickly replaced.;2|A fast-growing species, which is killed by fire.;3 |  | Usually grows in sand along watercourses in shrubland and open woodland in granite country; it also occurs in drier sites, including exposed ridges. Plants are naturally killed by flood-waters, but seed germinates readily and mature plants are quickly replaced. A fast-growing species, which is killed by fire.
Throughout its distribution it occurs in a wide range of arid and semi-arid habitats; mainly in the low shrubs and undergrowth of [NAME], but also in <em>Acacia</em> scrubs, dry sclerophyll woodland, heath, and native pine. However, in NSW it seems to occur almost exclusively in mallee habitats, with understorey dominated by spinifex, chenopods or other shrubs including <em>Acacia</em> species. Only rarely, such as in Cocoparra NP, is it recorded in other types of woodland, and in these areas a dense understorey may be a prerequisite.;1|Occupies vegetation with a wide range of fire histories, though appears to occur at highest densities in areas two to fifteen years post fire. There is some evidence from the Victorian mallee that if the interval between fires is too short (less than fifteen years) local declines may occur.;2|These birds forage on the ground, often among spinifex clumps, on a wide range of invertebrates (including grasshoppers, bugs, beetles,  flies, caterpillars and ants), seeds of both native and introduced species and, more rarely, fruits.;3|Its nest is a depression in the ground lined with strips of bark, fine grass or sticks, placed near a mallee trunk, against a fallen branch, under a low [NAME] or in a sparse tuft of grass. Almost always lays a clutch of two eggs.;4 |  | Throughout its distribution it occurs in a wide range of arid and semi-arid habitats; mainly in the low shrubs and undergrowth of [NAME], but also in [NAME] scrubs, dry sclerophyll woodland, heath, and native pine. However, in NSW it seems to occur almost exclusively in mallee habitats, with understorey dominated by spinifex, chenopods or other shrubs including [NAME] species. Only rarely, such as in Cocoparra NP, is it recorded in other types of woodland, and in these areas a dense understorey may be a prerequisite. Occupies vegetation with a wide range of fire histories, though appears to occur at highest densities in areas two to fifteen years post fire. There is some evidence from the Victorian mallee that if the interval between fires is too short (less than fifteen years) local declines may occur. These birds forage on the ground, often among spinifex clumps, on a wide range of invertebrates (including grasshoppers, bugs, beetles,  flies, caterpillars and ants), seeds of both native and introduced species and, more rarely, fruits. Its nest is a depression in the ground lined with strips of bark, fine grass or sticks, placed near a mallee trunk, against a fallen branch, under a low [NAME] or in a sparse tuft of grass. Almost always lays a clutch of two eggs.
The distribution of the Eastern Bristlebird has contracted to three disjunct areas of south-eastern Australia. There are three main populations: Northern - southern Queensland/northern NSW, Central - Barren Ground&nbsp;NR, [NAME], [NAME], [NAME], Booderee NP and Beecroft Peninsula&nbsp;and Southern - Nadgee NR and Croajingalong NP in the vicinity of the NSW/Victorian border. The estimated population size is less than 2000 individuals occupying a total area of about 120 sq km. There are now only four populations in the southern Queensland/northern NSW area with a total of 35 birds, compared to 15 years ago when 14 populations and 154 birds were recorded. This population once extended as far south as at least Dorrigo and has recently been identified as a separate ultrataxon (<em>monoides</em>) but further research is being undertaken to determine the validity of this. The remaining populations are the nominate ultrataxon (<em>brachypterus</em>) and once extended at least to what is now the Sydney urban area. The&nbsp;central population comprises an estimated 1600 birds, mainly from Barren Grounds Nature Reserve, Budderoo National Park and the Jervis Bay area. The southern population in Nadgee Nature Reserve and Howe's Flat is around 200 birds. Further surveys are required in parts of [NAME] and Sydney Catchment Authority lands to determine whether further populations of the Eastern Bristlebird occur in these areas. |  | The distribution of the Eastern Bristlebird has contracted to three disjunct areas of south-eastern Australia. There are three main populations: Northern - southern Queensland/northern NSW, Central - Barren Ground&nbsp;NR, [NAME], [NAME], [NAME], Booderee NP and Beecroft Peninsula and Southern - Nadgee NR and Croajingalong NP in the vicinity of the NSW/Victorian border. The estimated population size is less than 2000 individuals occupying a total area of about 120 sq km. There are now only four populations in the southern Queensland/northern NSW area with a total of 35 birds, compared to 15 years ago when 14 populations and 154 birds were recorded. This population once extended as far south as at least Dorrigo and has recently been identified as a separate ultrataxon but further research is being undertaken to determine the validity of this. The remaining populations are the nominate ultrataxon and once extended at least to what is now the Sydney urban area. The central population comprises an estimated 1600 birds, mainly from Barren Grounds Nature Reserve, Budderoo National Park and the Jervis Bay area. The southern population in Nadgee Nature Reserve and Howe's Flat is around 200 birds. Further surveys are required in parts of [NAME] and Sydney Catchment Authority lands to determine whether further populations of the Eastern Bristlebird occur in these areas.
<span style="font-family: arial; color: #1f497d; font-size: 10pt"><font color="#404040" face="Verdana"><span [NAME] whitii </font></span>is a medium sized, robust, rock dwelling skink, is brown above, grey or brown on the sides, usually with a series of dark brown or black spots on the back, which may be scattered or aligned longitudinally. It is found in rocky microhabitats in open woodland, heathland and grasslands over a wide geographic range in South Australia, Tasmania, Victoria, New South Wales and Queensland and it is not considered to be threatened. <p>A population of skinks formally known as <em>E. margaretae</em> have recently undergone taxonomic study and have been found to be a disjunct population of <em>Egernia whitii (E. whitii </em>is now known as&nbsp;<em>Liopholis whitii)</em>. This population is found in the Broken Hill Complex Bioregion and has been reproductively isolated from other populations of <span style="font-style: italic">L</span>. <em>whitii</em> sufficiently long for it to have undergone morphological differentiation. As such the Broken Hill population of <span style="font-style: italic">L</span>. <em>whitii</em> has been listed as an endangered population.</p> |  | [NAME] is a medium sized, robust, rock dwelling skink, is brown above, grey or brown on the sides, usually with a series of dark brown or black spots on the back, which may be scattered or aligned longitudinally. It is found in rocky microhabitats in open woodland, heathland and grasslands over a wide geographic range in South Australia, Tasmania, Victoria, New South Wales and Queensland and it is not considered to be threatened. A population of skinks formally known as E. margaretae have recently undergone taxonomic study and have been found to be a disjunct population of Egernia whitii (E. whitii is now known as Liopholis whitii. This population is found in the Broken Hill Complex Bioregion and has been reproductively isolated from other populations of L.whitii. sufficiently long for it to have undergone morphological differentiation. As such the Broken Hill population of L. whitii has been listed as an endangered population.