Question about Microsoft Office Standard for PC

1 Answer

Merge two records in ms works 2000

I want to be able to merge two or more records in Microsoft works 2000
I started with an ascii II file of addresses. I imported that list into an Excell spreadsheet. When I did this it put only part of the address on each row so when I imported into Excell each address became 4 or 5 different rows. Therefore the data base became 4 or 5 records.I would like to merge them into only one record.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

The easiest way I could think to do this was using text formulae concatenate - The issue I thought you might have was the lack of spaces between each entry - hence the " "

=CONCATENATE(B2," ",B3," ",B4,B5,B6)

Posted on May 21, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

Access 2007 corrupted database


back up files on external hard drive!! mirror hard drive, will keep corrupted file, it might cause further problems. you have lost some critical files, but you might have isolated a virus . Move on, do a clean install, after reload the backed up files one at a time.

Jan 11, 2015 | Microsoft Office Professional 2007 Full...

2 Answers

I have downloaded the MapiLab Mail Merge Toolkit to use with MS Word and Publisher. However, only Word displays the option to use it, not Publisher. I need to know how to enable it for Publisher.


Hi there,
The "MAPILab" folder is created in the "Start" menu. It contains the folders of all installed add-ins the way it is shown below in the menu:
ynogami21_3.jpg

Open the help of some installed add-in and see the "Introduction" or "Working with the program" sections to find the description on what control items it adds to the Microsoft Outlook toolbar and menu and under what conditions these items become visible and available.
If there are no described items in the Microsoft Outlook interface, make sure the add-in is loaded (look at the article "How is it possible that I cannot enable an add-in? What are "disabled items"?).

Hope this helps!

Sep 13, 2011 | MAPILab Mail Merge Toolkit

1 Answer

Error in ms office


Rename and Reinstall the Vbe6.dll File

NOTE: You need your Office CD-ROM to complete this task.
  1. Quit all currently open programs.
  2. Start an MS-DOS prompt in a window by doing one of the following:
    • Microsoft Windows 95 or Windows 98: Click Start, point to Programs, and then click MS-DOS Prompt.
    • Microsoft Windows Millennium Edition (Me): Click Start, point to Programs, point to Accessories, and then click MS-DOS Prompt.
    • Microsoft Windows NT 4.0: Click Start, point to Programs, and then click Command Prompt.
    • Microsoft Windows 2000 or Microsoft Windows XP: Click Start, point to Programs, point to Accessories, and then click Command Prompt.
  3. To change the directory to the location of the Vbe6.dll file, type one of the following (including the quotation marks), and then press ENTER: CD "C:\Program Files\Common Files\Microsoft Shared\Vba\Vba6"-or- CD progra~1\Common~1\Micros~1\Vba\Vba6NOTE: This is the default directory for the Vbe6.dll file. If you installed Microsoft Office into another drive or directory, you must type its path.
  4. To unregister the Vbe6.dll file, type the following.

    In Windows 95, Windows 98, or Windows Me, type: C:\Windows\System\REGSVR32 /U VBE6.DLLIn Windows NT 4.0, Windows 2000, or Windows XP, type: REGSVR32 /U VBE6.DLL-or- C:\Winnt\System32\REGSVR32 /U VBE6.DLLNOTE: This is the default directory for the Windows System directory. If you installed Windows into another directory, you must type its path.
  5. In the MS-DOS prompt window, rename Vbe.dll to Vbe.old by typing the following and then pressing ENTER: rename vbe6.dll vbe6.old
  6. Quit the MS-DOS prompt window. To do this, do one of the following:
    • Type Exit at the command prompt, and then press ENTER. -or-

    • Click Close (the X in the upper-right corner of the window).
  7. Start Microsoft Word.
  8. On the Tools menu, point to Macro, and then click Macros.

    The Windows Installer detects that the Vbe6.dll file is missing on the system, installs the file from the Office CD, and registers it again.

Mar 23, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Word 2007 problems with mail merge labels


YES, you have conflict with other program installed. Reinstall will not solve the problem, great solution is upgrade your Microsoft Office from 2007 to 2010 and surely you can print all the document once it is change to new office 2010.

Nov 23, 2009 | Microsoft Office Professional 2007 Full...

7 Answers

Undelete records from access table


ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer

HOW CAN I MATCH THE TWO WORKSHEET FOR RECONCILIATION


Try this:
1. Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
3. Click "Tools > Compare" and "Merge Workbooks." 4. Look for the files you want to merge and add them into the current file. 5. Click “OK” to merge the files. This is your master copy of this workbook. 6. Save the file.

Dec 21, 2008 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

2 Answers

Power Point file in MS 2000 is not opening in MS 2003 Power Point


Maybe you might need to downlaod and run a file format convertor from microsoft. I guess this is just a compatibility issue, microsoft program are not downward compatible in so many instances this is why i suggest, you run the file format convertor.

let me know if this works out for you.

Good luck

Jul 02, 2008 | Microsoft Office 2003 Pro (269-07387) for...

4 Answers

How to create mailing labels in Microsoft Works


With a Microsoft Works Word document open, select: Tools>Labels>(the list of available label types will pop up, select the label sheet you're using) then select: Tools>Mail Merge>Open Data Source...

Don't know how it could be simpler.

Dec 18, 2007 | Microsoft Works 8.0 for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...