Help to set point
Hi everyone, thank you for helping me solve the problem that I have. I need to put a point in the middle of a figure of six numbers, without changing the data on the right. The total data to modify is 1689 cells. Find and Replace. For example
430056;; -105 430.056;; -105
438900;; -104 438.900;;-104
Than you very mach
a solution depends on the layout of the real data.
If you just have one column of 6 digit numbers than a possible
- put the cursor to the place you want in the first line
- scroll to the last line (do not move the cursor)
- press SHIFT+ALT and click with the mouse to the position in the last line
this activate the column mode - press your dot key - done
A possible S/R is by using the regular expression
Done, but as said, depends on the real data.
Ohhh Claudia Thank you, many thanks from Spain!!!
The formula works perfectly and press shift + alt… also
Thank you very much…Have a nice day
Greetings from Spain!!!