1. In a single column I have a list of random words e.g in column A, I have 1000 words going vertically down, in columns 1 down to a 1000. I would like to know how I can add a comma to the end of each word automatically?
2. In column A I have a list of 2,609 words going vertically down (the amount of words could be any random amount - even and odd numbers). In column A for the first 20 words I would like to automatically put the words "GROUP 001" in Column B next to the first 20 words in column A, thus the words "GROUP 001" would be repeated 20 times in column B.
For the next 20 words in line in Column A, I would like to put the words "GROUP 002" in Column B, thus the words "GROUP 002" would be repeated 20 times in column B. In this example there are 2,609 words so 2,609 divided by 20 = 130.45, so there would be GROUP 001 to GROUP 131 in column B.
Using =A7&","&B7 to add data from two columns into one, separated by a comma. What about multiple columns, still separated by a comma? See Example in attachment.
I am writing and costing recipes, I have a liast of ingredients on one page in excel, these have amounts and cost in the row with them eg; Rice 1 kg 0.23
I want to type rice in my recipe and the rest of the row migrates automatically, is this possible?I am only a basic user, not sure how to put in formulas and things.
I'm having an issue with adding data to word from excel through VBA.
I would like to add the Table to the word doc, then copy and paste data below it. The code works fine. However, after the table gets added to the top of the word doc, the rest of the stuff begins pasting from the top of the doc, causing the table to appear at the bottom...
I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document. For example to declare a workbook in excel its
Dim wb As Work Book
I've tried
Dim doc As Word.Document 'or Dim doc As Word.Application
as shown in some of the forum posts, but an error user-type not defined keeps displaying.
Is it possible to export Excel cell contents to Word fields in a protected Word document? For example...
What code would be needed to tell Excel to open up, copy and export the contents of A2 in the active sheet of a workbook to "Field 2" in a Word document named "Report 01" and then put the contents of B2 to "Field 2" etc?
Do both applications have to be opened up at the same time or is Excel able to open up Word on its own? Will the macro be able to....
1. Automatically open up the correct Word document?
2. Look ONLY in a certain folder for the "Report 01" Word document?
or
Bring up a "selection" box that allows you to select the document you wish Excel to export it's data to?
3. Close and save the Word Document without any user intervention?
I need to count how many times the word Test is in the range B4:H9 with
Range N2 = Test the formula below works if Test is only in the cell once.
=COUNTIF($B$4:$H$9,"*" & N2 & "*")
But I have data in cells like below, this is all in one cell, so how would I have it count all the times test is in the range when some cells have test 2 or more times in a single cell?
I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.
There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"
1. I have a excel file with Japanese words in column A and their English equivalents in column B.
2. I am trying to create a Macro and assign it to a button. On pressing the button Macro should be able to:
3. open a form where I can enter location of a word file.
4. Macro should open the word file specified in (3).
5. Macro will pick up first Japanese word from excel file (Sheet 1 - A1)
6. Search for that word in Word file
7. Replace the Japanese words in Word file with their English equivalent from excel (B1)
8. Then it should search for second word (A2) and replace with its equivalent (B2) and so on till it reaches last filled cell in excel file column A.
After a lot of search I could find a code from net (Below), made a few changes, but it is not working.
======================================================== Private Sub OK_Click() ' Requires a reference to Microsoft Word xx.x Object Library Dim sFile As String
I have a list of 1735 numbers, actually they are numbers and/or alpha-numeric combinations. I need to copy this list of numbers into a report program. The report program requires six digits separated by a semi-colon (no spaces) with leading zeroes, as necessary.
To accomplish this, I format the cells under "Custom" and put in six zeroes. Now, I need to list them with no spaces between the numbers, just a semi colon. I have tried copying as "text only" into Word, and I get the full number, with the leading zeroes but I cannot figure out how to add the semi colons, no spaces, between each number. Can this be done in Excel? Every variation I try, including copy & paste values only, add the semi-colon into the next column and do =B2&C2, the leading zeroes drop off. If it can't be done in Excel, can it be done in Word?
I have a rather large file that I need to convert. Right now, there are about 3 columns and over 4500 rows. What I need to do is have everything separated by quotes and commas. I have a macro to somewhat do this, but it is putting an extra comma in front of everything. My question is this:
Is there a way to take out a comma that is in front of every entry?
OR
Is there another macro that will separate the columns with a single quote and comma, like below:
I copied my data and used the paste value function, pasted it onto another excel sheet and then saved as CSV. Ideally, there should be no formatting on the cells. However, column J threw some commas for which i am unable to understand.
All i want to do is put a control in place via VBA to remove all commas from the sheet.
Is there a VBA code that can perform this function?
I've imported a large document to excel. It contains 118 rows of information. My problem is that all the information is in column A. Every cell contains long sentences with information. The information is divided by a comma-sign (,). What i want to do is to seperate the information by columns instead of a commasign. So for example:
then, i want to permanently remove the comma, so the result : 123 12 9822 8267
Because if i use format cells -> use 1k separator, the data actually still contain the comma (even if the looks is 123, but in the formula bar, it stated 123,123567).
I cant seem to figure out how to use "Split". I searched in this forum and found a few posts but I did not understand the solved ones.
I have data in many rows in this format: $$ #901,11d3,[-B-] Ř.2494 +.0005/-.0000
The first thing to do is get rid of "$$ ", no biggie. Second is to split the data up based on the "," comma location. The above data would read #901 11d3 [-B-] Ř.2494 +.0005/-.0000
Each being in its own cell by "columns", thus the above break down would be in A2, A3 and A4 respectively assuming the original data is in A1.
Some strings of data can be over a hundred characters in length with multiple commas.
How would I concatenate a large range of cells, most of which are blank, and add a comma between each cell's value? My range is E2:Y2 (I will be filling down), but most of the cells are blank. For example, if I F2=9, I2=11 and X=25, I would like to display them as: 9,11,25. If in the next row, G=10, K=15 and Y=27, they should look like this: 10,15,27.
Is there a way to save as an excel file containing a list of words inone column so when I open it in Notepad I get the words in one line separated by commas?
create a macro that will create csv files for each worksheet of a workbook. The Macro works great. But i do have a requirement where i do not need extra commas (,) in the CSV. When the CSV are created for each worksheet, it adds additional commas in the end and my shell script throws it away becuase of the additional commas.
I have attached 3 files - csvtest.xls - this has the macro which creates individual csv files for EACH worksheet in the workbook........
And I am trying to see if there is a way to separate the data column into separate colums anywhere that a comma is present.Need data to look like this.
i have data exported as CSV from in house system, the problem is that data is separted by commas therefore some of cells have split, i need VBA to remove the commas and bring my data back into correct format. Below is a sample of what the data looks like, real data is 5000 rows of data
PFOLIO A/C CODE ACCT NAME CUR CODE DESCRIPTN NARRATIVE DATE ENTRY DATE CASH VALUE De --------------------------------------------------------------------------------------------------------------------------------------------ACA001AUDCUST JP MorganAUDINT0005 SALE 39727.08 INTECH BAL GR FD C29-Dec-082-Jan-09-27690.57N
I'm trying to separate text that have commas in between. I've got a column that contains commas and a few cells in those columns have commas and bracket. The problem occurs when there are more than two values WITHIN in the bracket that are separated by commas. How can parse the text in such a way where what ever is within the bracket remains in tact? For example: Controls, Motors, Transformers (LVoltage, High Performance, Medium Voltage). The goal is to separate everything before a comma but for Transformers I would like it to remain as 'Transformers (LVoltage, High Performance, Medium Voltage)'.
I have a list (general ledger) GL codes with trailing commas
Example: 123456789,123456722,123789456,,,,,
When I try to use “replace” and replace the multiple commas with nothing it turns my gl codes into a scientific number (1.23456789123456E+26), but my cell is formatted to text.
The other problem is for numbers with a single trailing comma, it would also remove the commas between the GL codes
Is there a function that removes trailing commas, or commas that are not followed by numbers?
