Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Convert Word labels to Excel spreadsheet

I know how to use the mail merge feature from Excel to Word, but how about
from existing labels in Word to a usable Excel spreadsheet. My approaches
have been to save word as .txt and then get external data in Excel. That
works great accept I need to be able to have different column fields like
Name, Address, City, State etc. What is the best way to go about doing this?
Any help?? Thank you in advance.


Post your answer or comment

comments powered by Disqus
I know how to use the mail merge feature from Excel to Word, but how
about from existing labels in Word to a usable Excel spreadsheet. My
approaches have been to save word as .txt and then get external data in
Excel. That works great accept I need to be able to have different
column fields like Name, Address, City, State etc. What is the best way
to go about doing this?
Any help?? Thank you in advance.

How can I convert a word address label document back into an Excel spreadsheet?

Thanks for the help.

G.

I received labels from a client in a Word doc. I need to convert the labels into an Excel spreadsheet. Any moderately easy way to get this done?

I am willing to pay $300.00 USD for this solution.

I have hundreds of job description Word documents similar to the example attached "200001_LP_Housing_Program_Mgr_Job_Description" saved in folders.

Bottom line I need to convert them into either Excel or Access or any other way that will allow me to manipulate them in a spreadsheet similar to the example attached "Bot Outcome Example" that I manually created. vs. Individually opening each Word job description, pasting it into Excel or whatever and then manually labeling the sections/ order and job code #. All word documents are labeled to begin with the 6 digit job code so if there is a way that a bot or a macro or whatever type of converter could
automatically open the word docs from a folder and paste the content into a spreadsheet column C (in my example),
pull the job code from the file name and populate column A (in my example),
and then last populate column B with the order/ section of the description using the key words by section or Job Summary down to Essential Functions to Minimum Qualifications and last to Knolwedge, Skills & Abilities.

This would allow us to sort/ scrub in a database vs. having to do manually paste individually by job description. There are bullets and different formats in some descriptions that could potentially impact the quality of the transfer of the data. Further, in some cases the job description templates could be slightly different formats however.. they ALL have the same key words by section listed above including Job Summary down to Essential Functions to Minimum Qualifications and last to Knolwedge, Skills & Abilities.

We will be completing job descriptions in groups over time, so a solution that is set up that I could just apply to job description folders in batches as I go would be perfect (vs. I have all of them saved in 1 folder ready to go you take it and do it)

Hopefully my rambling directions made a bit of sense but let me know if you have any further questions.

Thanks for your time, Cheers!

Hi -
I have a number of word documents that are labels, not originating from a data merge from excel, that I need to get into an excel document.

They are set up in tables in word for labels, but I need each label to be its' own row in Excel, and separate each field.

An example:

First Name Last Name
Company
Address
City St Zip

I need the excel document to be in rows, with each field it's own cell:
First Name | Last Name | Company| Address| City | St | Zip

Is there any way to get this word information into an excel spreadsheet without having to retype all of it?

Any help would be greatly appreciated!

I have a word document that I need converted to an excel spreadsheet. can this be done? if so can anyone help me?

Thanks

Keith

I have 35 pages of labels in MS Word that I would like to export in to Excel. Is there a way to do this? I would like to be able to seperate the information (Name, Street Address, City, State, and Zip) if it is possible without having to retype everything that is there.

i have one word file and needs to convert to excel.

I have an existing Word doc in table format. Some columns contain bulleted
items. How can I convert to Excel maintaining the bulleted format?

Hi guys,

I am trying to convert the attached Word document into Excel and retain the same formatting.

What I would like to build in is the calculation option for check boxes where by if a particular check box is selected, it will automatically calculate the points (mentioned underneth the check box) and return the total value of all check boxes under the section in "PAYROLL TAX" where it says total points.

It doesnt have to be check boxes, it could also be radio buttons. Whatever works easier.

Thanks in advance for your help!!!

I have an evaluation form I need to convert from word to excel; as to
implement formulas to make the scoring easier to maintain or more accurate.
I am having trouble since the original word doc has numerous tables and such.
I am not that excel savvy..HELP

This is what I have on word doc:

7/28/2008 JOB NUMBER CUSTOMER AREA1 50.00 50.00
7/28/2008 JOB NUMBER CUSTOMER AREA3 50.00 50.00
7/28/2008 JOB NUMBER CUSTOMER AREA8 75.00 75.00
7/29/2008 JOB NUMBER CUSTOMER AREA3 50.00 50.00
7/30/2008 JOB NUMBER CUSTOMER AREA5 50.00 50.00
7/30/2008 JOB NUMBER CUSTOMER AREA3 50.00 50.00
7/30/2008 JOB NUMBER CUSTOMER AREA8 50.00 50.00
7/30/2008 JOB NUMBER CUSTOMER AREA5 50.00 50.00
7/30/2008 JOB NUMBER CUSTOMER AREA6 75.00 75.00
7/31/2008 JOB NUMBER CUSTOMER AREA3 50 .00 50.00

How can I transfer this to excel on to 6 different cells so that I cansort it by date, by customer, by job number, or by area... Is this even possible?
Thanks for any help

Thank you

I want to use excel to start logging calls, how do I copy the data that resides on a word table to a spreadsheet without losing the formatting. Are there any call log software out there to make this job easier?

Any help will be greatly appreciated.

I found this thread on the now defunct Google Answers that is spot on to my problem, but their solution didn't work:
http://answers.google.com/answers/threadview?id=319322

As you are probably aware, if you try to simply cut & paste a word table to excel, any carriage returns within a table cell will cause multiple rows in excel, and will cause the rest of the cells in that row that have no carriage returns to appear as merged cells.

In my case, I had a bunch of cells w/ soft carriage returns, but I was able to replace them using "^l" in the Find field in Word.

As described in the above thread, Excel does not recognize such codes as "^p" or "^l" in the Find/Replace fields, and anyway, I cannot simply use the Find/Replace function because I get a "Formula is too long." error.

Here is the code provided by aht-gt in the Google Answers thread:

Public Function ReplaceCharacter(ByVal s As String, ByVal oldchar As String, ByVal newchar As String) As String
Dim sVal As String

'Set the late binding objects
Dim rPart As Object

sVal = s

Set rPart = CreateObject("VBScript.RegExp")
rPart.Global = True
rPart.IgnoreCase = True
rPart.Pattern = oldchar

'replace all occurences of the pattern c with the
sVal = rPart.Replace(sVal, newchar)

Set rPart = Nothing

ReplaceCharacter = sVal

End Function

Sub MyReplace()
Dim s As String

On Error GoTo MyReplaceAbort

Application.DisplayStatusBar = True
Application.StatusBar = "Replacing Characters..."
Application.ScreenUpdating = False

For Each c In Selection.Cells
c.Value = ReplaceCharacter(c.Value, "~", Chr(10))
Next c

MyReplaceAbort:

Application.ScreenUpdating = True
Application.StatusBar = False
Application.DisplayStatusBar = True

End Sub

I used "qqq" as my dummy string, so I changed the "~" in his code to "qqq".
I ran the macro, and instead of replacing my dummy string w/ a line break, it replaced it with the string "^l". I also tried changing the "Chr(10)" in his code with "Chr(13)" and "Chr(10) & Chr(13)", and the results were the same.
How &^%$#@! asinine is that?
I have thousands of table rows, and it just isn't realistic fixing all of these carriage returns manually.

Can someone please suggest some alternatives here, or possibly explain why his code isn't working?

I'm running Excel 2003 SP 2.

Thanks.

Hi there. How can I convert csv file to excel file with proper columns filled with data being separated by "comma" in csv?

Cheers.

How to convert prn files to excel files?

Dear Friends,

I have an query regards to transfering a data from word bookmarks to excel cell using VBA. Can someone recommend a code to me...

For E.g

I have a bookmarks name "DOI" and transferring data to excel cell "A1". Using a button on word document.

Regards
HD

Dear Friends,

I am very much disappointed and unable to find any answer to my this problem, that means this file has to be converted to excel, I have tried finding the solution on net, any one on the board will please come forward to help me in this project of converting this file to excel.

I do hereby attach the file to be converted, and the formated / converted excel sample file.

Please some one help me to sort this ?

Is there a way to get a clean, formatted transfer of Word tables to
Excel? What I've done is do a Word Save-as to Web (HTML), and then
import this into Excel.

However, I'm going blind working in Excel fixing small errors, such as
values that were togther in a single Word table cell being rendered as
two cells, and cell tint being lost completely, and cell orientation
and justification. I have to manually resize rows and columns. Is there
a tool for doing this conversion, or methods I can use to minimize or
eliminate these problems?

I need help to transfert web tables to excel spreadsheet...

i need code to extract the tables from :

http://www.nhl.com/scores/htmlreport...9/PL020745.HTM

...and paste it into excel worksheet.

thanks in advance!

Hi - I'm using Excel 2003 and am receiving a bunch of addresses in separate Microsoft Word documents formatted as labels that I want to make an excel spreadsheet out of. Is there an easy way to copy the labels and paste them in Excel so that they ultimately result in three columns (A column to be NAME, B column to be STREET ADDRESS, C column to be CITY, STATE, ZIP)?

Right now, all I could think of was to paste a column of the addresses at at time into Column A in Excel... then if my first label pasted into excel as cells A1, A2, A3... my formula in cell B1 would be =A1, formula in cell C1 would be =A2, formula in cell D1 would be =A3... and then copy these three formulas down... but it doesn't feel like the most efficient way to do this?

Anyone have a better way?

I'm seriously seeking a method to convert MS Word labels to an excel SS so I can load the data into a contact management database.

Can anyone help?

Thanks

I'm trying to convert an old address list written in word into an excel
spreadsheet.. The addresses are basic 3 lines (name, address, city, state,
zip). Other than copying each item into each cell individually, is there a
way to do this more efficiently?

I am receiving the results of a Web-based test via e-mail. I am able to paste the e-mail's contents into an Excel spreadsheet and use it to manipulate the data as necessary, with one exception, namely an answer that requires the test taker to write a multi-paragraph e-mail response. I am able to identify which cells in Column A this answer occupies, for sake of argument, A60 to A70.

I want to have the contents of these cells appear in a single cell, B60, with linefeeds. I did find an Excel macro on this forum:

Sub FlexConcating()
Dim cell As Range
Dim r As Integer
Dim c As Integer
Dim Cnt As Integer
Cnt = -1
Dim strRslt As String
   For Each cell In Selection
       r = cell.Row
       c = cell.Column
       Cnt = Cnt + 1
       strRslt = strRslt & vbCrLf & cell
   Next cell
   Cells(r - Cnt, c + 1) = strRslt
End Sub
This works after a fashion, but there are undesirable leading spaces at the beginning of each paragraph.

If I instead copy the cells into a Word document, I notice that they come through as a table. If I convert the table to text in Word, then paste it back into the formula bar of B60, I get what I want.

My question is, can this be done wholly within Excel, without the need for Word?

Thanks in advance for any help on this.

Burt Spielman
Madison, NJ


No luck finding an answer? You could always try Google.