Extracting Numbers...

[amt0803]

I have a lot of cells with data like this....

110-55
94-107
89-123

What is the most efficient way to simply knock off the - and everything after it? I want those cells to be:

110
94
89

I appreciate your help.

 

[acw]

Hi

One way would be to make sure there is a blank column next to the data, then do a data, text to columns using "-" as the delimiter. This will leave the required data in the current column and put the remaining in the spare column which can then be deleted / cleared as required.


Tony

 

[barry houdini]

Use Edit > Replace and replace

-*

with nothing

 

[amt0803]

Thank you both.