I need to work out how to remove the the data from the column in left hand side so that it is shown in the right hand column.
The data highlighted in black in the first column will vary in length. I do not require any data in the first column which is shown after the first space.
i.e I only need data 102.194 from the first column and moved into the second.
See Screenshot (2nd one i.e last one as 1st one is wrong)
Also , when l move the data across to the right column l need to remove the full stop as this character is NOT required, so 102.194 should be 102194.