Results 1 to 11 of 11

Pasting single digit numbers in a separate cells

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2019
    Location
    Malta
    MS-Off Ver
    2007
    Posts
    4

    Pasting single digit numbers in a separate cells

    Hi all,

    Have a little problem. I need to copy & paste some numbers from pdf to excel. In each line there are either 2 digit or 1 digit number.
    2 digit numbers are pasting ok - each number in separate line, however 1 digit numbers are put in the same cell.

    Please look at the attachments.

    Is there any way to go about it?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to subtract single cells with double digits into a single digit of a single cell.
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-11-2021, 02:05 AM
  2. [SOLVED] Separate the last digit and find the numbers tesla 3,6,9
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2018, 12:15 PM
  3. [SOLVED] Macro to convert WBS single digit numbers to double digit numbers
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-09-2018, 05:25 AM
  4. [SOLVED] Extract each digit from 3 Digit Numbers and put in other cells?
    By Brian.Aerojet in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-21-2017, 08:20 PM
  5. [SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2014, 12:57 AM
  6. [SOLVED] Add Zero to single digit numbers
    By vin1602 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 06:49 AM
  7. Adding 5 numbers to a single 3 digit
    By wd8ekd in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 07-26-2008, 01:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1