Seperate specific information from cell

I have a colum of product names in which data is like this: 

Nestle Nesquik Strawberry 300g

		<p>OR like this:&nbsp;</p>

		<table border="0" cellpadding="0" cellspacing="0" style="width:428pt">
			<tbody>
				<tr>
					<td style="height:15pt; width:428pt">
					<p><strong>Nestle Nesquik Strawberry (300g)</strong></p>
					</td>
				</tr>
			</tbody>
		</table>
		</td>
	</tr>
</tbody>

I want to seperate the weights from product name and save them in another column. In my data, weights are whether seperated by space, or a bracket. 

					<p>How can I do this?</p>
					</td>
				</tr>
			</tbody>
		</table>
		</td>
	</tr>
</tbody>

From what you describe, you should use the Cell Splitter and add the delimeter character. For your first example you use "space" for the second you use "(". That automatically saves the info in a new column, but it does split up the whole Product name. YOu can easily fix that and concatenate/merge again the split prodeuct name columns and you will have the weight left over too.

 

Is this something that helps you ?

It should, let me try. thanks :)

 

There's a problem. Every product have different number of spaces in them.For eg: "Nestle Nesquik Strawberry 300g)" has 3 spaces so the name will split into 4 parts but "Red Bull 250 ml" has total 2 spaces means 3 splits. 

At the end which columns should be merged?

Try a regular expression:

\d+\s?(?:g|ml)

(would match digits followed by optional space, folled by either 'g' or 'ml').

-- Philipp

Which would help you only sofar as the stuff comes in g or ml.
There might be l, litre, gallon, kg, kilo, mg, milligram, sixpacks, bushels, tons, barrels, pallets, ....

First replacing ( with a space and ) with nothing, and then splitting on the last number using a regex makes more sense, but you will still have to check that it does what you think it should.
You might find out that there is for example one instance where it says something like "Product x  6 bottles of 500ml"

Textual information has a tendency to be funny like that.