Hi Professionals.

I am new to vba programming as I am originally from an Oracle background.

anyway I have a number of very large spreadsheets which have a column with version numbers from various vendors, what I am looking to do is enable my work colleagues to just click a button and ammend the versions by looking for the first . and replace something like this

version numbers raw
11.3.2.1
10.5.2.1
10.4.1.1
401.3.2
null
unknown

amended
11.x
10.x
10.x
401.x
version unknown
version unknown

can this be done via a button click

thanks all