Navigation

    Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Help to set point

    Help wanted · · · – – – · · ·
    2
    4
    1863
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jesus Heras
      Jesus Heras last edited by

      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

      Claudia Frank 1 Reply Last reply Reply Quote 0
      • Claudia Frank
        Claudia Frank @Jesus Heras last edited by

        @Jesus-Heras

        a solution depends on the layout of the real data.
        If you just have one column of 6 digit numbers than a possible
        solution is

        • 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
        Find what:

        ^\d{3}
        

        Replace with:

        $0.
        

        Done, but as said, depends on the real data.

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0
        • Jesus Heras
          Jesus Heras last edited by

          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!!!

          Jesús!!

          Claudia Frank 1 Reply Last reply Reply Quote 0
          • Claudia Frank
            Claudia Frank @Jesus Heras last edited by

            @Jesus-Heras

            ¡De nada!

            Cheers
            Claudia

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Copyright © 2014 NodeBB Forums | Contributors