Removing excess information from a calc cell

asked 2018-05-11 22:34:24 +0200

stuarts.burgers gravatar image

I have a Column of Street Numbers that include unit/flat number as per below 2, 4, 5, 7, 7, 10, 17, 17, 18, 18, 1/1, 11B, 12A, 16A, 2/1, 3/1, 9A, I need strip off the Flat Number with the /, ie 2/1 I need to show as 1,

I have used Column to Text "other" with a string of A B C etc to remove the Unit Letters but how do I remove the flat numbers and the /. The flat numbers could be one or two digits.

edit retag flag offensive close merge delete