Pls. help merge two long columns!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: cgreenberg (chipg_at_pvtn.net)
Date: 03/30/04 

Date: 30 Mar 2004 11:03:43 -0800

Could somebody pls. help me merge two columns of data.

I have two columns, each about 2k entries long with 3 digits in each
cell. I'd like to merge the digits from column b behind those in
column a. I see how to do that one at a time, anybody have a trick on
doing this globally?

Example:

Column a/1 entry 212, Column b/1 entry 210. I'd like one column with
212210.

Again, I have 2000 of these! Sure would appreciate any help

Chip

Relevant Pages

  • Re: Creating a Password
    ... If a user limits a password to only digits, wouldn't the "possible" entries ... >> letters in the dictionary when possible. ... > "Without knowledge you have fear, with fear you create your own ...
    (microsoft.public.security)
  • Grouping variable length values
    ... characters. ... My difficulty is that when I sort them, ... group them based on on the section of digits just before the last. ... The 6 entries below would be grouped as described. ...
    (microsoft.public.access.reports)
  • Re: Adding Zeros as placeholders
    ... significant digits. ... >> Seth, ... >>> this works for items that are left justified and entries ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Grouping variable length values
    ... characters. ... group them based on on the section of digits just before the last. ... The 6 entries below would be grouped as described. ... It seems like the presence of a space character is the key ...
    (microsoft.public.access.reports)
  • Re: ICE
    ... Most mobile phones will display a number when two entries have the ... > same digits. ...
    (uk.local.surrey)