Deleting "<=" from a number

[peterfitz]

• I am transferring test results accross three computer systems - the first remote computer generates test results which are exported to an Excel sheet which I receive.
• I get test results in column A
• The results may vary in the number of characters. Numeric range will be between 1000.0 down to 0.675

• Typical figures:

469
139
14.8
1.690
<=0.675

• Using third part software, Column B converts these numbers to a barcode.
• The sheet is then printed.
• The barcodes in column B are then used to scan the test results into another computer system which does not recognize the 'less than or equal to' notation.

How can I remove the "<=" where it exists, such that the barcode generated will read only the remaining digits? in the example above, <=0.675 should display 0.675

I have rounded up the usual suspects such as left$, find, substitute, custom formatting etc, but can't get it to work as I need.

I don't want to generate another column (if possible), i.e, I'd like to display the final result in it's original cell.

Any guidance would be appreciated.

Thanks

Peter

 

[schielrn]

You should be able to do find and replace and replace with nothing assuming that isn't anywhere else in the sheet?

 

[peterfitz]

True, and this works. However, the data will ultimately be entered by those not too familiar with Excel, so I am trying to automate the process as much as possible, and also lock it down so results dont get altered unintentionally.

If push came to shove I could have them run short macro, but I was hoping for a formula solution which would require no intervention on their part. For example could the 'find and replace' function be worded into a IF -Then_else formula?

Peter

 

[schielrn]

If you use an if statement, you are still going to need to use another column won't you?