Convert Excel records to text documents in arbitary formats

D

Doug Blaisdell

Hi,

A newbie here (groan). I need a tool to take data in excel tables and
generate text documents with the data rearranged in new forms, eg to
look somewhat like mailing labels (but with more data items, like
email address). Is there a tool that will take Excel data and generate
documents in arbitrary formats?

Also, is there a tool to edit column data, eg. the Name field I have
is all uppercase, and I wanted to cap the first and make the others
lower case (eg: JONES -> Jones), a pain in the ass if done manually.
Generally, an editing tool for column data.

thanks in advance
 
R

Richard O. Neville

Don't know how to do your first request, but maybe can help on the second.
First, make a copy of the Excel sheet in case of error. Copy the column(s)
to a blank Word document and select Format-Change Case. After reformatting,
copy the data back to Excel.
 
L

Lady Layla

Easier way, add a column next to the column in ?, enter =Proper(cell with name
in it), copy down, select data in the column you added, copy, select colum with
original data, Paste Special Values


You can set a form up in Word and then do a mail merge ??


: Don't know how to do your first request, but maybe can help on the second.
: First, make a copy of the Excel sheet in case of error. Copy the column(s)
: to a blank Word document and select Format-Change Case. After reformatting,
: copy the data back to Excel.
:
: : > Hi,
: >
: > A newbie here (groan). I need a tool to take data in excel tables and
: > generate text documents with the data rearranged in new forms, eg to
: > look somewhat like mailing labels (but with more data items, like
: > email address). Is there a tool that will take Excel data and generate
: > documents in arbitrary formats?
: >
: > Also, is there a tool to edit column data, eg. the Name field I have
: > is all uppercase, and I wanted to cap the first and make the others
: > lower case (eg: JONES -> Jones), a pain in the ass if done manually.
: > Generally, an editing tool for column data.
: >
: > thanks in advance
:
:
 
Top