Hi,

To use VBA to modify cell contents, there needs to be some sort of logical pattern you can include.

In your examples, there isn't an obvious pattern (not obvious to me, at least).

For example:

In this case, the cell contains the text "data123-124" and it seems that you want to remove anything from the hyphen onwards.
In this example it seems that the cell contains the text "data123 & 5020" and you want to remove anything from the first space onwards.
In this example, the cell seems to contain the text "data 123b" and you want to remove just the final character (ie. not from the first space).
Please can you clarify a set of rules as to what should be removed? Is it that you want to remove any characters which follow the first complete number?
Please also clarify if this is a one-off event, or something that has to happen with regularity?

Hope that helps...