Change text within a cell

[thundermocos]

Hello All,

I am looking for some help on changing text within a cell. For example, text "LotNumber=7100" on one spreadsheet is being copied over to another spreadsheet. However on the new spreadsheet all that is required is 7100. So I am looking for some type of way to eliminate the "LotNumber=" from the text. Here is the problem though, 7100 changes, it incriments upwards with each new spreadsheet. So I would need someway for the code to handle that the text in the cell changes.

Thanks in Advance

[daddylonglegs]

If the cells always contain LotNumber=xxx try something like

=SUBSTITUTE(Sheet1!A1,"LotNumber=","")+0

[thundermocos]

That works, thanks long legs. I was wondering if there is a way to have the macro delete text in a cell, for instance, I want to delete the first 8 characters in a cell. Example, LotNumber=56203.01 I can clear the LotNumber= using your code, but in anther box I only need "01". The number is always changing, so something that would go in the box and delete the first 6 characters in a cell, leaving me only with the actual wafer number, which in this case is "01". Problems are the wafer numbers are not sequential and the Lot number changes frequently.

[paulmezick]

Is the wafer number always 2 digits? If it is you could do something like this:

Please Login or Register  to view this content.

Where the above case Range("B4") Would be the LotNumber in cell b4. B5 would then return the last 2 digits of the lot number.

[thundermocos]

It is and that is exactly what i was looking for!

Thanks Paul