<div>
Place this function in a module
</div>


<div>
Thanks for that but it doesn't work for &quot;Book Plot 9,234.00 plus any extra text which may include a randum number &nbsp;102 for example&quot;.<br />
<br />
You get the whole string
</div>


<div>
Many thanks for the joint answer
</div>


<div>
<div class="content wysiwyg-content">
I am using Excel 2003<br />
<br />
I am looking for vba code that will look at a cell and delete all spaces and text after the first occuring string of numbers (this could be any random numbers 100.00 or 10,000 or 0.00 or 0 &nbsp;with or without a decimal point).<br />
<br />
Therefore if the cell has &quot;Marketing Area 234.0 plus any text which may include a randum number like 99&quot; what I need is &quot;Marketing Area 234.0&quot;<br />
<br />
Therefore if the cell has &quot;Book Plot 9,234 plus any extra text which may include a randum number &nbsp;102 for example&quot; what I need is &quot;Book Plot 9,234&quot;<br />
<br />
Many thanks
</div>
</div>


I am using Excel 2003

I am looking for vba code that will look at a cell and delete all spaces and text after the first occuring string of numbers (this could be any random numbers 100.00 or 10,000 or 0.00 or 0  with or without a decimal point).

Therefore if the cell has "Marketing Area 234.0 plus any text which may include a randum number like 99" what I need is "Marketing Area 234.0"

Therefore if the cell has "Book Plot 9,234 plus any extra text which may include a randum number  102 for example" what I need is "Book Plot 9,234"

Many thanks

Thanks for that but it doesn&#39;t work for &quot;Book Plot 9,234.00 plus any extra text which may include a randum number  102 for example&quot;.

You get the whole string

Deleting text after a number with vba

I am using Excel 2003

I am looking for vba code that will look at a cell and delete all spaces and text after the first occuring string of numbers (this could be any random numbers 100.00 or 10,000 or 0.00 or 0  with or without a decimal point).

Therefore if the cell has &quot;Marketing Area 234.0 plus any text which may include a randum number like 99&quot; what I need is &quot;Marketing Area 234.0&quot;

Therefore if the cell has &quot;Book Plot 9,234 plus any extra text which may include a randum number  102 for example&quot; what I need is &quot;Book Plot 9,234&quot;

Many thanks

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.