Windows Support Forum

Number data in 10 columns and 25 rows pasted from other source is text

Q: Number data in 10 columns and 25 rows pasted from other source is text

..... and I want to convert the lot to 2 decimal place numbers.

Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work.

Is the only way to solve my problem to manually enter the numbers elsewhere, clear the original cells, and then cut and paste back to the original cells?

Help please!

Relevancy 100%
Preferred Solution: Number data in 10 columns and 25 rows pasted from other source is text

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

A: Number data in 10 columns and 25 rows pasted from other source is text

Need more info about the source text file. When opened in Word and Show All (the paragraph mark) is enabled, what does the text file look like?

See this thread from a couple years ago and see if it gives you any ideas:

Please Help - Data in Text File to be arranged in Excel in a specific

Relevancy 109.65%

I have data that repeats hundreds of times. I am trying to put each string of data on 1 line.

f-name(A2) initial(B2) l-name(C2) ID#(D2) DOB(E2) Street(F2) company(G2)
City(F3) company#(G3)
Home Phone(F5)
Work Phone(F6)

After the data is moved to one line I would like to delete the lines that previously housed the information. The company# can be deleted. I have never worked with macros. I would appreciate any help given.

A:Solved: move data from rows and columns to other rows and columns

Relevancy 98.04%

Hi There

It has been quite a while since I asked for help. I wonder if the following is doable as an Excel macro. The attached is only a demo with only 2 fields and a few rows of data. The real worksheet has more fields and around 3,000 rows.

Sheet 1 contains the data in its initial state and sheet 2 contains data after the macro is run. You will see from sheet 2 that the field labeled QUANTITY determines the number of rows to insert and copy the correct data into those inserted rows. I want the entire row to be copied down as opposed to only the data, since I have more columns than shown here. Is this possible to do? Can anyone help me with writing a macro, since I have over 3,000 rows to do.

Thanks for all your help. You guys are fantastic.


A:Inserting specific number of rows in Excel and copying data in those inserted rows
Relevancy 98.04%

Hi I am trying to copy and insert rows based on a number in cell E. If the number in cell E is 4, I would like to copy 3 additional rows beneath the original and then also number the 4 rows into column F consecutively for each group. I am attaching a spreadsheet of before and after. Sheet 1 is the before and sheet 2 is the after. Can anyone help me with this. I have tried another code but it not work properly. I did find one that would put blank rows in but I cannot get past that. Any input is greatly appreciated.

Thank you


A:insert rows based on number in cell and copy the data down into the new rows

Hi Peg

Try this solution and see if it is ok for you. I've put in some code to help prevent the running of the code multiple times on the same sheet. If you don't need this safeguard you can delete the block of code that does this.

Also, make sure and make a backup of your file before running this - just in case.
Relevancy 97.18%

I know you can hide and unhide rows and columns but can you make it so they don't even exist?

I have a just under 2m picture I want to put as a background but when you put the file as a background it tiles it the whole 256 columns and 65,536 rows even if I have them hidden.

This makes my 2.5m spreadsheet over 32 megs in size even with the columns/rows hidden.

I need to be able to see the lines on this above the picture for this project and I can't find any way to do this. I thought I could put it in the background but this pesky problem turned up.

I tried adding more space to the jpg that was empty white space but this too also increased the file size.

Relevancy 96.32%

I have been working on a project for a few weeks and I could really use some help I m attaching a dummy file example that is an example of how my XLS comes to me each month I need a Solved: to delete specific XLS Macro move to columns rows/columns rows. and macro that leaves me with the second file example If the macro could just grab the Student name then put the following info for each student all on row that would be perfect Child s Name Date In Time In Rounded Time Out Rounded Sometimes for some reason there is a student with Solved: XLS Macro to delete specific rows/columns and move columns to rows. a Cont after their name I need that row deleted and just pull the times up onto the same row as other times The example file might make sense Here are the steps I am doing manually that I hope a macro could do for Solved: XLS Macro to delete specific rows/columns and move columns to rows. me Un-merge cells B Un-merge any cells with a child s name such as Doe Jane Delete any row with a childs name that has Cont after it such as Doe Jane Cont Delete rows - Delete columns A C F H I J M N O and P Manually move all info up to one row per student Delete all empty rows below See example as the completed file but I only moved a few of the rows per student for the sake of time Is there any way to do all of this with a macro nbsp

A:Solved: XLS Macro to delete specific rows/columns and move columns to rows.
Relevancy 95.46%

I started out with the two previous posts about macros (post 1, post 2) that move rows into columns, but I'm having a little trouble getting it to work for what I need. First, I'm trying to do a data merge into Word, but in order to get the data merge to work/look the way I want it to, I need the XLS data to be in columns.

I'm attaching an example file that has one worksheet of the sample data (though my "real" data has about 300 rows) and the other worksheet is an example of the outcome I need.

Is there anyway I can do what I need? Exporting into another file or another worksheet within this file would be fine.

Thanks in advance.

A:XLS Macro to move data to columns, delete empty rows, delete duplicate columns
Relevancy 92.88%


I have imported sales data in excel. The information lists in along two rows with mutliple columns. I need the information to be in one row under various headings. I have attached a link to a sample to explain this properly. I think I need to use a macro but I don't understand enough about them to make it work.

Any help would be much appreciated.

Relevancy 92.02%

I have data in columns - starting A Data columns Formulas Creating from in in rows - P and another set of data from A -P I have various formulae using that data starting in A -A I wish to include the second row of data the A -P into a second set of formulas from B -B Filling right doesn t work because if the formula in the A column is something as simple as quot A C D quot when I fill right the formula in the B column is quot B D E quot - when I NEED it to read quot A C D quot I realize there is probably a simple workaround for this - in fact I COULD just rekey the formula the reasons I don t are the formulas are more elaborate than I listed there will be many more rows of data at least more - Creating Formulas in rows from Data in columns so rekeying the formula for EACH row of data would be time-consuming and it will eventually move the formulas off the same visible area as the data I m currently combatting that by having the panes frozen Is there any way to accomplish what I m trying to get done Chris nbsp

Relevancy 92.02%

Hi A does anyone know how to search for the text content Searching Rows/Columns EXCEL Data in of a cell through a column and then return the value content of the cell of a certain other column of the same row where the text content was found e g A B C D T XY TP YZ TP ZY P YX TP YY FORMULA TP ZZ gt gt FORMULA EXCEL Searching Data in Rows/Columns quot Look for string TP in column A other than in EXCEL Searching Data in Rows/Columns row and return the value of that row in column C C YZ quot NOTE There might be more than row with the string TP in column A - I would need the sum of all results in column C where the FORMULA finds this string B I also have a similar problem with another worksheet It would require a formula which searches through a whole column for certain names e g quot Donna quot and then returns the value of another column in the same row where it found quot Donna quot the value again is not in a column directly EXCEL Searching Data in Rows/Columns adjacent to the column where quot Donna quot would be found This is fairly identical to problem A except that the search string would be unique only result and it doesn t have to take into account and disregard if the string was found in the same row of the FORMULA the search column would be in a different worksheet from the FORMULA worksheet Thanks for any suggestions Cheers from New Zealand Andreas nbsp

Relevancy 92.02%

I have a very large spreadsheet (i.e. too big for pivoting and transposing wouldn't work) which looks something like this:
Col. ACol. BCol. CCol. DCol. ECol. FCol. GEntry1Info124562131654632435435Entry2Info150256874654242454654Entry3Info2221333333336546548463
I want it to look like this (i.e. flip Col.C through Col. G and line it up with Entry1, then do the same for Entry2, etc.):

Col. ACol. BCol. CEntry1Info12Entry1Info456Entry1Info2131Entry1Info6546Entry1Info32435435Entry2Info150Entry2Info25Entry2Info6874654Entry2Info242Entry2Info454654Entry3Info222Entry3Info133333Entry3Info333Entry3Info654654Entry3Info8463

Please help!

Relevancy 90.73%

We have a survey package which is great, but it out puts the questions numbers over the columns and each new row is a response, however our calculations are setup for the question numbers to be the rows and the responses are the columns. Is there any way to swap these values around in this fashion? Thanks for any help

A:Excel: swapping columns and rows layout of data?

Howdy. You can copy the data, then Paste Special > Transpose
Relevancy 89.87%

I'm a novice excel VBA macro user. I've manipulated already created macros, but I'm not sure how to create one from scratch. Can someone please help me create a macro.

I'd like to move the values highlighted in yellow to the cells highlighted in green...and then delete any rows that are empty.

Thanks in advance for the help.

Relevancy 89.01%

quot Macro Creation Request for Moving Data from Rows to Columns in a Non-Conventional Way quot Hello all Hopefully somebody can help me with the following problem please see the attached document Presently I have an Excel document containing variables - per country in rows for label through label x However I need the table to contain the country level information as Columns Way Data Request Rows Moving for in from Macro Non-Conventional Creation a to columns Macro Creation Request for Moving Data from Rows to Columns in a Non-Conventional Way for each label so that there is only one row per label For example instead of row containing label argentina variables - then row containing label arab emirates variables - I need the table to contain row label columns argentina variable argentina variable etc then arab emirates variables arab emirates variable etc Also the countries in the table that do not have information for a given label fall at the end of the list for each label instead of in alphabetical order Macro Creation Request for Moving Data from Rows to Columns in a Non-Conventional Way but they need to be placed in Macro Creation Request for Moving Data from Rows to Columns in a Non-Conventional Way alphabetical order when quot columnized quot I have provided the arab emirates as an example Alphabetically it comes before Argentina but in the list it comes after because it did not contain information for those given labels Since information per country will vary from label to label the countries must remain in alphabetical order in the columns regardless of whether information is provided or not per label Is there a macro that may be written for this Thank you so much in advance for taking the time to read my post Happy day nbsp

A:Macro Creation Request for Moving Data from Rows to Columns in a Non-Conventional Way
Relevancy 87.29%

I need a visual basic macro for excel that will do the following From sheet ColumnA Select rows until sheet columnA value does not start with REC as the no of rows is unbalanced sometimes rows sometimes rows sometimes rows etc copy selected rows and transpose to sheet columnA to however many rows were selected Repeat until end for 2002 to in new Visual columns Excel data unbalanced Basic rows sheet using Macro last row My real table has rows and the rows are unbalanced I am attaching a test file Please help me and thank you for your support and time Tech Support Guy System Info Utility Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data version OS Version Microsoft Windows XP Professional Service Pack bit Processor Pentium R Dual-Core CPU E GHz x Family Model Stepping Processor Count RAM Mb Graphics Card ATI Radeon HD Series Mb Hard Drives F Total - MB Free - MB G Total - MB Free - MB H Total - MB Free - MB Motherboard MICRO-STAR INTERNATIONAL CO LTD G M -L V MS- Antivirus None nbsp

A:Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data

Can you also attach a second workbook showing how the data should appear after the macro is run?

Relevancy 83.85%

I do a weekly report that I base on results that I get with search done in Internet Explorer I can then cut and paste these results into an Excel spreadsheet moving unwanted Rows, Question: rows Solved: Excel to new Removing columns some but I need to delete most of the information whole rows and reorganize the remaining rows by taking the even numbered rows and putting them into the B column then delete that Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns Row as well I have included some images that should help Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns A few more items The information that I paste into the excel spredsheet may contain up to but no more than lines from the original copying source in Explorer I m not sure how many lines that translates into Excel After every records in Explorer there is a quot top quot link that gets copied which needs to be taken into consideration when deleting the extra rows entirely Another way to look at this is that I ONLY want to keep the rows that have the digit number a space then more digits as well as the rows that contain the price with the For instance the first record in my example I ONLY kept amp The price will ALWAYS have a and the first set of number will ALWAYS have digits first no letters Attached is a jpg that shows the various steps the last screen shot has a few of the cells highlighted in the upper left hand side Those highlighted cells is all of the information I need and how I need it presented from the first search records the MLS number and the price Thanks nbsp

A:Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns
Relevancy 79.98%

How do I know how many records I have in my Data Source that I've created? In Word 2007, each record was assigned a number as you created it, visible on the screen. In 2010, I don't see the same thing which makes it difficult to run a merge "from - to" if you don't know the number of the record. Thanx. Alan
Relevancy 76.97%

I tried out this formula, =IF(B10<>"",COUNTA($B$10:B10),""), to number the rows in a column that have data in adjacent columns, but leave a row un-numbered and uncounted if the adjacent cell was blank. It worked great in Column A.

However, I tried using the formula in column D and it didn't work so well. Instead of numbering in sequence it was counting by 3's. 3, 6, 9, 12 etc. It still skipped the rows with no data in the adjacent cells but the numbering was wrong.

I tried making some changes no no avail.

This is the formula in D10: =IF(E10<>"",COUNTA($B$10:E10),"")

Any ideas on how to make this formula work in Column D?


A:Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A


I think your problem is with your formula having a static reference for the first part of the array in the COUNTA (The dollar signs). Since you have the reference in the original location as $B$10:B10, when you copied it over, it kept the reference so your new location is counting across columns B through E. You can fix this 1 of 2 ways. You can modify only the formula in column D to read =IF(E10<>"",COUNTA($E$10:E10)"").

Alternatively, you could change your original formula and recopy it. The dollar signs will keep the reference they are in front of static, so if you changed your original formula to =IF(B10<>"",COUNTA(B$10:B10),"") and copied it, the column label would change relatively.

The final recommendation I'm going to give is a new formula that I think gives you the same result but with easier formulas.


This will give a true/false value based on whether or not the targeted cell is blank, and then return the current row number. Let me know if you need any further assistance!
Relevancy 74.82%

User has text boxes within cells of a table in Word 2003. Originally files were created in Word 97.

Copies text boxes into another existing file and the text changes size and will not fully show inside text box ie. it is chopped off. If copies text boxes into a brand new document, the paste is fine, all sizes correct.

When doing the paste, smart tag option of keep source formatting is selected but this seems to make no difference.

Any ideas?

A:Text resizing inside Text Boxes when copied/pasted

tinsel10 said:

User has text boxes within cells of a table in Word 2003. Originally files were created in Word 97.

Copies text boxes into another existing file and the text changes size and will not fully show inside text box ie. it is chopped off. If copies text boxes into a brand new document, the paste is fine, all sizes correct.

When doing the paste, smart tag option of keep source formatting is selected but this seems to make no difference.

Any ideas?Click to expand...

Since you copy into an existing file, have you tried to enlarge the text area into which you copy in the existing file - try doing it before you copy into the text box if that is possible.

-- Tom
Relevancy 74.39%

Basically each morning I import data from an internet database to excel.
I need to divide the number of rows, that i receive daily in this excel document, to 4 worksheets designated to 4 staff members.
Each staff member needs to receive an equal amount of rows.

For e.g. if today i received 124 rows of data then each staff member should get 31 rows each.
Except the number of rows will vary on each day. I could get 200 plus rows of data.

Can someone please assist with writing a macro to divide up the rows in to the 4 worksheets? I would be very appreciative. Thanks in advance

I have attached the sample file for viewing....the data starts from row 3...thanks

A:Solved: Excel Macro to divide any number of rows equally onto certain number of works
Relevancy 71.38%

I have formulas that has the data setup in rows (input). The next sheet is formulas that are in columns referencing these individual rows (output). When column A's formulas are dragged to column B, the references change as expected but to Sheet1!B1 rather than Sheet1!A2 (back to the rows). I think I 've done this before, but can't for the life of me remember how. Help me please and I'll be your best friend! (hey, it's the best I can do).



A:Excel Columns to Rows

Select all the cells involved

Right click anywhere on your selection and from the menu that pops up choose Copy

Click in the cell where you want the list to begin then Right click and from the menu choose Paste special you will now see another menu.

At the bottom right hand side of this menu, Select Transpose.

That's it your list will now run across the page instead of down
Relevancy 71.38%


I do not know much about excel so i need your help.
Attached is a screenshot. Please examine it a bit to know which rows and columns the data responds to.

Now that you done that heres the question:

How can i switch the dates to the top row and the exercises to where the dates are but keeping the readouts of the weight measurements to its corresponding labels?
I looked over it and it seemed like i had to do it manually but i am wondering if there was a way to automatically do it? Without all the hard work

A:Flip the rows and columns

Check out the function =Transpose()

Type into the top cell you want to put the new table (I'll use A32), and using your screenshot values:
In cell A32: "=Transpose(A1:K27)" (don't use ") after you type that in, select starting at that cell the same area for your new table - all the cells.

So select A32 and select to AA42, then press F2, hold down Ctrl & Shift, and then Enter, and it will Transpose the vertical to the horizontal and all the corresponding data.

Transpose is brilliant.

I recommend that you then copy the information from that and use paste special and keep values, then delete the complete rows with the transposed array, its annoying cos you can't change the info, so just turn it back into cell data is the best option.

Unless you want to put it on another sheet, and want it to update from your original data.
Relevancy 71.38%

Copy Rows into columns using VBA1 have a very little experience with VBA, and I would really appreciate any help with this issue. I need to convert rows into columns from sheet 1 to sheet 2.input file Article ID EU-statistics Number of sheets Size of sheet Absorbancy With empties BOM (Empties Bill of Material)1062 a 0 b 0 c1065 a 0 b 0 c1066 a 0 b 0 c1071 a 0 b 0 c1077 a 0 b 0 c1081 a 0 b 0 c1086 a 0 b 0 c1090 a 0 b 0 cDesire output file Article ID 1062 EU-statistics a1062 Number of sheets 01062 Size of sheet b1062 Absorbancy 01062 With empties BOM (Empties Bill of Material) c1065 EU-statistics a1065 Number of sheets 01065 Size of sheet b1065 Absorbancy 01065 With empties BOM (Empties Bill of Material) c1066 EU-statistics a1066 Number of sheets 01066 Size of sheet b1066 Absorbancy 01066 With empties BOM (Empties Bill of Material) c
Relevancy 71.38%

Isn't it possible to freeze a specific row or column, rather than panes?

A:freezing rows/ columns

If you are talking Excel then you can freeze the Top rows and side columns as headings, but I don't think you can freeze individual rows/columns anywhere else on the worksheet.
Relevancy 70.52%

I had a similar post and thought it I understood the solution, but did not. Solution called for Pivot tables and it's not quite working for me. Just wondering whether a VBA file would better serve the purpose. Please look at the attached file. Many, many thanks for the kind help. (Running Excel 2003 on an XP- SP3 machine.)

Relevancy 70.52%

I am really new to Excel (2003) and have read several similar posts to mine below; but cannot adapt the existing programming to accomplish the task. I wish to convert a data in “Book A” to appear like that of “Book B”
This will be an almost daily repetitive task. Please refer to the attachment. Thanks for looking. Any thoughts on the subject will be greatly appreciated.

System information:System Board: ECS K7S5A Chipset: SiS 735
CPU: AMD @ 1200 MHz
System Memory: 4x1024MB (DDR SDRAM)
Bios: AMI (11/21/01)
Video: onboard
Audio: Creative SB Live!
Op System: Win XP - Pro SP3 with all updates

Relevancy 70.52%

I remember seeing somewhere that you can convert rows to columns in Excel, where the numbers would be across the top and the letters down the side. How is that accomplished? Also, if there is data in the spreadsheet at the time, will it be converted too or will it just change the tabs?

Relevancy 70.52%

how can the contents in cells A1, A2 and A3 be transposed so that they are on the same row, AND always on the same row as B1; and

how can the contents in cells A4, A5 and A6 be transposed so that they are on the same row, AND always on the same row as B4.

a sample worksheet is attached.


Relevancy 70.52%

When I attempt to insert a column or a row, I'm getting a message from MS Excel:
"Cannot shift objects off sheet".
Can someone advise me as to what I must do to correct this?
Also, what have I done to cause this to happen?
Thank you for your help.

A:Solved: Inserting Columns or Rows

hi floydcojacket,

I think this is connected with your earlier issue with cell comments.

I'm now sure you must have your Advanced Options, Display Options for this Workbook- Display Objects set to Hide.

That option is in the next block below the Display options for Comments.

Relevancy 70.52%

I have some Excel files that only take up 50 - 100 rows, but the scroll bar on the side is very tiny (as if I had used the worksheet to the bottom). Is there a way to get rid of these unwanted rows at the end? I've highlighted and deleted them, but they just get replaced. Is there a simple way, withouht copying the data to a new file?


A:Excel - Getting rid of extra rows/columns

Copy and paste the cells into a new worksheet. By default, Excel opens a Workbook with 3 Worksheets. After copying andpasting the info, nad verifying that itlooks the way you want, then you can right-click the worksheet tab at the bottom and delte the old one.
Relevancy 70.52%

Hi all. First post so be kind! Bit of a novice at VBA, but i am sure this is possible..
basically, I have a contact list in Excel that I need to format 'correctly'. It is currently formatted with the address on multiple rows, with phone number and email address in another column ( i have attached a dummy file). I would like to 'move' data so it is in correct columns...
Name Address1 Address2 Address3 Address4 Address5 Phone Email

To make matters a bit trickier, the number of address rows varies, so it might be 5 rows or sometimes 3; and not all contacts have an email address (although they would always be in row "2" of a contact address.

Many thanks in advance for any advice


Relevancy 70.52%

Hi I would like to put names or numbers on the columns and rows Ive managed to get a table to work for me its a set of multiples for the first cell is blank the next headings EXCEL, on i columns?? put Can and rows is the first entry and i put in this case here the rest of the table fills itself in with multiples of Thing is when i print it out i want the columns and rows to have headings Is there a way to do this please The drawing is only aproximate i have to convert to bmp then add in the extra numbers which EXCEL, Can i put headings on rows and columns?? dont change they could be background the colour doesnt matter it is only there to separate the columns and rows from the multiples of Later if its or i would use the same table lt img src quot http forums techguy org attachment php postid quot gt by using the tens and units you get the multiple at the intersection row and column give the result for times There might be better ways but this works ok Regards John nbsp

A:EXCEL, Can i put headings on rows and columns??

I set up the rows and column headings the way you want.
Then I hid the "real" row and column headings.
You can left-click to view it.
Right-click and choose Save target as to save it.
Relevancy 69.66%

I have an excel file with single worksheet. The file is about 4-5 print pages in A4 size. The excel file has titles in first column and 5th row. I want to repeat these titles in every pages when printing. How do I do this. Can I use macros for this.

A:Repeating rows and columns for printing in excel

Relevancy 69.66%

I need to convert rows to columns in Excel like this:

Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Monday | 6
Tuesday | 7
Wednesday | 8
Thursday | 9
Friday | 0


Monday | Tuesday | Wednesday | Thursday | Friday
1 | 2 | 3 | 4 | 5
6 | 7 | 8 | 9 | 0

Is this possible?

Well, that didn't display at all like I expected. In short, I need the repeating headers in column A to become one set of headers in row 1 with the data corresponding to each header name below it. Does that make sense?

A:Solved: Excel Rows to Columns with a Twist

Try this :

1) copy the days i.e(MondayTuesdayWednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday
2) Go to the required cell and right click and select "paste special as" then select "Transpose"
You will get the data in this shape
MondayTuesdayWednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday
4) Repeat the same step for other data............
Relevancy 69.66%


I need help in Excel copying columns and paste it in rows.

Ex: I have Columns A and B.
Column A Column B
5.78% 4.51%
23.60% 32.50%
14.17% 16.41%
32.12% 54.16%

Now output should be in one row.

Row1 5.78% 4.51% 23.60% 32.50% 14.17% 16.41% 32.12% 54.16%

A:Copy columns and paste in rows in Excel

sub test()
dim rng as range
dim i as long
dim col as long
dim nextcol as long
dim lastrow as long
lastrow = range("A"&rows.count).end(xlup)
set rng = range("A2:B"&lastrow)
nextcol =col+1
for i=2 to lastrow
range(cells(i,1),cells(i,col)).copy cells(1,nextcol)
end sub
Relevancy 69.66%


I have data in the following row format:

0 4591 5 4491 10 4461 15 4441 20 4321

The data are X and Z points so the above example shows 5 pairs of data. I would like to place these pairs of data sequentially in two columns where one column has all the X's and the other has the related Z's. I have many, many rows of similar data that I need transferred into two columns.

0 4591
5 4491
10 4461
15 4441
20 4321

Could anyone help me out with a macro that can do this for me?

Thanks very much in advance.

A:Solved: Excel Macro - Rows to Columns

Welcome to the board.

Let's say the example pairs are in A1:J1.

With A1:J1 selected,

Sub test()
For Each Cell In Selection
If Cell.Column Mod 2 = 1 Then
Range("A" & Rows.Count).End(xlUp).Offset(1) = Cell.Value
Range("B" & Rows.Count).End(xlUp).Offset(1) = Cell.Value
End If
Next Cell
End Sub

gives you actual pairs in A2:B6.

So, what do we need to adjust to make it compatible with your "many, many rows of similar data" scenario?
Relevancy 69.66%

Okay got a convoluted Rows vs - Non-Adjacent Columns Filling Formula spreadsheet going on amp I m not entirely sure how to describe it in words I tried several searches on these forums and on Google but I didn t find anything that was relevant So I m going to apologize in advance if I m re-posting a topic due to my inability to use the appropriate vocabulary to describe this Non-Adjacent Formula Filling - Columns vs Rows problem Running Windows XP Professional SP Excel I ve attached an example spreadsheet Here s the simplest way I can describe it Test is the first spreadsheet I m working with - All the data is already filled in by a vertical organization - This spreadsheet will be updated on a regular basis I m trying to have the data in the columns moved over to another sheet - Horizontal organization This can not be compromised - Absolutely necessary - This is being done by formulas of course - This needs to be done on separate pages i e Jack should have his own page Jill should have her own page - It would be preferable to find a way to use the Fill command as there are more records currently and more coming or at least a way to automate the proper filling Is there any way in which this can be done with merged cells If not then I don t mind doing it with un-merged cells - Merged Cell Version is quot Test quot Sheet - Un-Merged Cell Version is quot Test quot Sheet Both the Vertical amp Horizontal Based Spreadsheets are going to be updated on a regular basis but the first sheet is always going to take precedence basically the nd sheet is going to be working off of the data in the first spreadsheet nbsp

Relevancy 68.8%

Hi, I'm new to macro. Hope you can help me with my problem. I've been stuck with this for a week with no result.

I have this table:

001 002 003 004
111 115 119 123
112 116 120 124
113 117 121 125

Let's say, the first row are the StoreID and all other digits below them are the ProductID

I want to convert this table into something like this:
001 111
001 112
001 113
002 115
002 116
002 117
003 119
003 120
003 121
004 123
004 124
004 125

I haven't made any macro before in MS Excel and this one is really getting the breath out of me.

Hope you can help me please.. I'd really appreciate it.

Thank you in advance!

A:Help with Macro in excel - Convert Rows to Repeating Columns

is this just a "one off" thing or do you have many sheets to convert? Because for one or a few sheets, it is not a lot of work to do manually...probably take a few minutes ( I 'll explain if you need)

to automate I can do it, but I need to build some loops and references to refer to the columns and ranges to move to a new's a bit of work.

Please confirm also if it is only 4 columns, and or if the column count varies
Relevancy 68.8%

Hi Again

CodeLexicon gave me a code that worked very well in hiding column A only. Is it possible to make the macro hide all columns with all zeros?? Also I tried to change CodeLexicon's macro to do hide all rows whose columns have zeros but without success. I tried to make the code generic.

Attached is a workbook with the 2 macros. Test the macro that I did out and see that it only hides row A only.


Relevancy 68.8%

I have a flat file that when I read it into excel it populates column 1 of each row with data.
This data is actually a series of 5 fields that I need to have in columns and rows, that is,
column a1 thru a5 I need placed in a1, b1,c1,d1 and e1 followed by
column a6 thru a10 placed in a2,b2,c2,d2 and e2.
The data is balanced, that ism there is data in each of the 5 fields for a "record".
Any help would be appreciated.

Relevancy 68.8%

Hello - I found a previous post on this site that solves (I think) 90% of what I need to accomplish. I have a large spreadsheet that I need to:

· Delete column C
· Delete all rows without account numbers (Acct numbers will always be in column A)
· Delete all rows that have dates in column F other than “00/00/0000”.

The code I found on this site is :

Simple vba code:
lastrow = Range( "A65536").end(xlup).row
For y = LastRow To 2 Step -1
If Cells(y, x).Value = "" Then Cells(y, x).Delete shift:=xlUp
Next y
Set the range to the the column desired, in this case "A"
Lastrow checks the last row and starts from the end up.
Removes all empty rows entirely up to row 2 because row 1 generally is the header
Happy coding
Can anyone help me?

A:Excel 07 MACRO to delete rows/columns w/ criteria

Delete all rows without account numbers (Acct numbers will always be in column A)Click to expand...

If there are no acct numbers, will there be

blanks ""
Space " "
dash -
other ??
Can you provide a sample with dummy data so we can see the data structure?
Relevancy 68.8%

Hi all,

this came up in conversation recently and I thought I knew the answer but was proved wrong.

when you insert a row (or column), it sometimes (but not always) copies the format from the preceeding row (or column).

what are the criteria that determine this?

I thought it was based upon something like if the preceeding 5ish rows were all the same format but it's not that!


Just realised I don't know how to add a link to a previous post!!
btw I used the macro in the posting 11-Aug-2004 "Insert Row Automation" which solves the above nicely (thanks Anne), but I'm still curious for the above criteria.
btw the 'InserARow' macro needs a row test at the beginning to check that you aren't insering above row 1 'cos there aint a row 0 to copy down from!
Relevancy 68.8%

In my work environment we are writing test cases and for the test steps we use a word table Its the same columns so we can load them into the Quality Center environment One issue we had was our review tool doesn to macro insert columns and table new rows into Word a t support word but does text documents The format of the table Word macro to insert new rows and columns into a table was kind of messy when we saved as a text document in the sense it would lump all the stuff together with no clean breaks As a solution people making every other row and column blank so there would be a break in the text format Once the review was complete you would have to then go back into that word doc and delete all the blank rows and columns to load into Quality Center Not hard but time consuming with the number of test we would deal with I wrote a quick macro that would delete the header in the table plus all the blank rows and columns Now what we have is we are re using these test and adding to them Currently we are pulling them out of quality center adding the blank rows and columns back in adding our updates sending back out for review deleting the blank rows and columns macro does this load back into Quality Center There may be a better way to go about this but what I am after is this A macro that will insert a blank row and column every other row and column I have been off and on playing with this for a few days but really have gotten no where with it Posted on a few non technical forum and they suggested posting on this site for some help I tried searching and didn t come up with anything like my scenario so hopefully not asking something previously asked Thanks nbsp
Relevancy 68.8%

Hello - I found a previous post on this site that solves (I think) 90% of what I need to accomplish. I have a large spreadsheet that I need to:

· Delete column C
· Delete all rows without account numbers (Acct numbers will always be in column A)
· Delete all rows that have dates in column F other than &#8220;00/00/0000&#8221;.

The code I found on this site is :

Simple vba code:
lastrow = Range( "A65536").end(xlup).row
For y = LastRow To 2 Step -1
If Cells(y, x).Value = "" Then Cells(y, x).Delete shift:=xlUp
Next y
Set the range to the the column desired, in this case "A"
Lastrow checks the last row and starts from the end up.
Removes all empty rows entirely up to row 2 because row 1 generally is the header
Happy coding
Can anyone help me?

A:Excel VBA Macro to delete rows/columns with criteria

To delete column c, use:
Delete all rows without account numbers (Acct numbers will always be in column A)
If Cells(y, "A").Value = "" Then Cells(y, "A").Delete shift:=xlUp

lastrow = cells(rows.count,1).end(xlup).row
For y = LastRow To 2 Step -1
If Cells(y, "A").Value = "" Then Rows(y).EntireRow.Delete
If Cells(y, "F").Value = “00/00/0000” Then Rows(y).EntireRow.Delete ' Delete all rows that have dates in column F other than “00/00/0000”.
Next y
Relevancy 68.37%

My PC at work has recently changed to Windows 7 and I have come across a printing problem I have never had before in any version of windows. In my day to day work I do a lot of copying and pasting of tables and their headings from an internet based work's program to a Word document and then print the document. However, with Windows 7 my problem is that the headings on my tables do not print. They show on print preview as normal but there is just a space on the printed document where the headings should be. The rest of the table prints as it always has and is fine. Help please as I'm tearing my hair out!

A:Pasted text not printing

 Uh, you neglected to say what you're pasting INTO.  That is key to diagnosing your problem because I suspect whatever app that might be.  
Please download and run Speccy.  After running it click File -> Publish snapshot... Copy and paste the link it gives you into your next post.
Relevancy 68.37%

Well..glad I found this forum. I would like to be able to populate a word document from an excel worksheet, with the ability to select (highlight) multiple rows in excel and have those rows transferred to word, but only certain columns

I found almost the right macro here:

Except you can only select (1) row.

Any coding solutions on how to copy a range of rows? This will also require the .Text in the word paste to change....
I see some hope with this code as well, but figuring it out may take me longer than someone that does this everyday.
Thank you.

Relevancy 68.37%

Ive spent so much time on this, I want to pull my hair out.

I have a pdf file of addresses. I converted the pdf to an excel file (the one I uploaded).

My eventual goal is to convert the addresses into excel, then do a mail merge into word.

I found a tool (via this great site) called ASAP utilities that I can turn the rows into columns, thats easy.

But the problem is, the addresses aren't always the same length. Some labels are 4 rows, others are 6 rows.

Is there any way I can either automatically make the rows 6 each without doing it manually? Or does anyone have any type of suggestion?

Thanks so much for the help

A:Converting excel rows (addresses) to columns for mail merge

Firstly, can I assume that you have permission to use those addresses for your own mailing?

If so you could go back to the originator and ask them to give you a CSV file, or maybe see if the pdf file can be saved as a CSV file.

If so, it would be very easy to bring that into Excel and then convert the file from text to Columns, using the Data, Text to Columns feature.
Relevancy 68.37%

I am un able to get an existing word file to open I can Doc Word Select Populate (Multiple Columns) Rows, Excel from get the following to open a new word file I need this to opoen an existing file Sub export Word row Dim oWD As Object Dim wdDoc As Object Dim TWB As Workbook wsh wsh As Worksheet Set TWB ThisWorkbook On Error Populate Word Doc from Excel (Multiple Rows, Select Columns) Resume Next Set oWD GetObject quot Word Application quot If Err Number lt gt Then Set oWD CreateObject quot Populate Word Doc from Excel (Multiple Rows, Select Columns) Word Application quot Err Clear Set wdDoc oWD documents Add With wdDoc With Range paragraphs Range Text quot PICK UP amp DELIVERY quot amp Chr Font Size Font Name quot Times New Roman quot Font Bold True Font Underline True ParagraphFormat Alignment End With With Range paragraphs Range Text quot PICK UP quot amp vbTab amp Cells row quot K quot Value amp vbTab amp Chr Font Size Font Name quot Times New Roman quot Font Bold True Font Underline True ParagraphFormat Alignment End With With Range paragraphs Range Text Chr amp Chr amp Chr amp Chr Font Size Font Underline False ParagraphFormat TabStops ClearAll DefaultTabStop Application CentimetersToPoints ParagraphFormat TabStops Add Position Application CentimetersToPoints Alignment Leader End With With Range paragraphs Range Text quot NAME quot amp vbTab amp Cells row quot B quot Value amp vbTab amp Cells row quot C quot Value amp Chr amp quot ADDRESS quot amp vbTab amp Cells row quot D quot Value amp vbTab amp Cells row quot E quot Value amp Chr amp quot PHONE quot amp vbTab amp Cells row quot R quot Value amp Chr amp quot MODEL quot amp vbTab amp Cells row quot F quot Value amp Chr amp quot VIN quot amp vbTab amp Cells row quot G quot Value amp Chr amp Chr amp quot WORK TO PERFORM quot amp quot quot amp vbTab amp Cells row quot I quot Value amp Chr amp Chr amp Chr amp quot SPECIAL INSTRUCTIONS quot amp quot quot amp vbTab amp Cells row quot J quot Value amp Chr Font Size Font Name quot Times New Roman quot Font Bold False ParagraphFormat Alignment End With End With oWD Visible True wdDoc Activate End Sub nbsp

A:Populate Word Doc from Excel (Multiple Rows, Select Columns)

Welcome to the forum
You should paste your code in a code clock

[ code ]

no spaces in between the []

[ / code ]

Set wdDoc = oWD.documents.Add

To open a word doc

Set wdDoc = oWD.documents.Open(fullpath and name of the file)

This should do the trick
Relevancy 68.37%

In Sheet one I have some raw data which in sheet two I have picked out the useful pieces and Fill another across sheet in move rows to Excel I problem. need columns have then input into out work forms The problem is that I need to fill the form across column but in the sheet that it is referenced from I need it to take the data from the row EX sheet one a b c a b c a b c a b c I Excel problem. Fill columns I need to move across rows in another sheet need to find a way to automatically get it to do this referencing sheet in column A and then filling to the right but actually having it go down the rows in sheet sheet a b c a a a b b b c c c the idea is that when the software exports to sheet we will be able to print sheet two in the form we need it without having to make any changes I know my explanation is a little crude but if someone could help me I would appreciate it thanks nbsp

A:Excel problem. Fill columns I need to move across rows in another sheet

You could use:


in Sheet2!A1, then replicate that down an across (pro forma style).

Would that help?
Relevancy 67.51%

Hello everyone The following question was asked way back in but I can t find the answer and I ve got exactly the same problem today I would be really grateful for help with this - I have copied and pasted a long article coming in at pages and Page Help - Won't Please Fill Pasted Text I want to reduce it to pages Please help a humble non-computerized soul out I Pasted Text Won't Fill Page - Please Help have pasted pages of text into word from an e-mail I want to print it out but each line only goes halfway across the screen and then begins a new line The borders are maximized and it should really be reduced to only pages in length but I can t figure out how to make the pasted text fill the document side to side without going through it line by line and deleting the empty spaces they seem to be the result of hitting enter I ve done this before with short e-mails and usually I just go through line by line and delete the spaces But this time it will take me hours and hours to do that There has to be a way to make the text fill the page please help Thank you nbsp

A:Pasted Text Won't Fill Page - Please Help

I suspect that the 'copy' is also coping the 'end of line markers' off the original line length ... past your 'copies' into a non-formating writing program like MS Notepad.

Notepad will strip out any and all format except, I believe, paragraph returns. I may be wrong on the last bit. Then copy-n-paste into Word, or whatever you're using.

You will, however, have to reformat the whole thing to match the original.

Now, after saying all that, you could, if using MS Word turn on the 'formatting controls' so you can see where & what format has been set, then, once again you will have to go through the whole document to check the format to the way you want it.

Either way, I think you's in for a long haul, good luck, hoped that helped.
Welcome to the forums.
Relevancy 67.51%

Excel 2000

I have created a calender ( actually a schedule) in excel which has multiple rows columns (A9:O36). The schedule shows where everyone works that day (eg billy on fries, johnny on grill, susie on cashier)

At the bottom I want to create one box which shows what days each worked and where

..................Fries | Grill | Cashier |

I've tried Sum. sumif, countif, if-then even an array...
Can't seem to do it or find the answer through searching
The closest I've come is the array, but I don't know how to make it work for a range of cells that is not a column
Any thoughts would be appreciated.

A:Solved: count instances that occur in multiple rows/columns after criteria met
Relevancy 67.51%

for some reason, this afternoon they began showing only ONE column, on the left side of the folder. the remainder of the folder is blank. see attached screen shot.
thanks for helping, boyd.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD Athlon(tm) II P340 Dual-Core Processor, AMD64 Family 16 Model 6 Stepping 3
Processor Count: 2
RAM: 2810 Mb
Graphics Card: AMD M880G with ATI Mobility Radeon HD 4250, 256 Mb
Hard Drives: C: Total - 288256 MB, Free - 112291 MB; D: Total - 16683 MB, Free - 2407 MB; F: Total - 99 MB, Free - 89 MB;
Motherboard: Hewlett-Packard, 1444
Antivirus: AntiVir Desktop, Updated: Yes, On-Demand Scanner: Disabled

A:Solved: Folders no longer show rows and columns of icons/thumbnails.

Thanks for the screen shot; makes it very clear what you are describing.

If you select a file it will preview it in the Preview pane (maybe not all types of files). If you'd like the Preview pane smaller and the main area larger drag the divider to the right. If you don't want the Preview pane at all get rid of it (Organize - Layout - remove check from Preview pane).
Relevancy 66.22%

I am working through a textbook on Word 2000. It happens to be in Chinese, and my version of Word is also Chinese, but I don't believe this is causing my problem.

According to the textbook, when I select text in Word and drag it to the desktop, a "scrap document" is created. Dragging this object back into the Word document at any point is supposed to paste the text that was originally selected and dragged to the desktop; in my case an icon of that scrap object is what gets pasted. What do I need to do so that Word acts as described in my textbook? I tried it on a friend's computer, and it did paste the text, not the icon, but I can't figure out why it won't work that way on my computer

A:Word Scrap object pasted as icon not text - Why?

Uh-oh. Mine works like your friend's does. What version, Sidhu? I have SR-1. Have you tried cut/paste instead of dragging? Just a thought. Let me know your version. Maybe we'll try cleaning up your Word registry entries and see if that helps?

Brainbench MVP for Microsoft Word
Relevancy 66.22%

It seems there used to be a windows interface for the clipbrd exe utility but if there is one in Windows I cannot find it I am trying to add lt cr gt line break or lt Enter gt characters to the end of anything I put in the clipboard before it gets pasted back Since different applications appear to treat pasted items differently I would prefer to have them even if they are quot extra quot or in addition to any added by pasting into a particular program of two carriage to images all automatically pasted text or add returns the time I am pasting to Notepad But it seems that i get the same results no matter what i paste to or copy from The text or image that is copied always pastes to everything with no break If i click Paste or Ctrl v twice in a row automatically add two carriage returns to all pasted text or images I get the items or automatically add two carriage returns to all pasted text or images text exactly side by side no quot eof quot marker or anything else When trying to copy text to create a quot list quot it requires clicking lt Enter gt twice after each paste to get it double spaced Or at least once to keep it from not even going to the next line In windows it seems the default action included a line-feed after the paste and it was an issue to try to strip out the lt cr gt 's Is there any way to get them back in Windows

A:automatically add two carriage returns to all pasted text or images

Not exactly what I wanted but darned close. Program called Ditto. Does this and much more
Relevancy 66.22%

Hello I ve long used a simple macro on various spreadsheets to reset the last used cell Sub Reset Range Application ActiveSheet UsedRange End then Excel 2003 range reset to & delete columns rows, macro Solved: blank Sub This works fine but prior to using it I would have to press CTRL End to see where the current last cell is then manually delete any blank columns and rows appearing at the end of the data by selecting them by their column letters row numbers right clicking and selecting Delete Failure to do this would mean the macro didn t successfully correct the last used cell I would like to add this stage into the Solved: Excel 2003 macro to delete blank columns & rows, then reset range macro I found some code on the web that allegedly removes all blank rows and columns so I pasted it at the top of my existing macro Option Explicit Sub DeleteBlankRows Dim Rw As Solved: Excel 2003 macro to delete blank columns & rows, then reset range Long RwCnt As Long Rng As Range Application ScreenUpdating False Application Calculation xlCalculationManual On Error GoTo Exits If Selection Rows count gt Then Set Rng Selection Else Set Rng Range Rows Rows Solved: Excel 2003 macro to delete blank columns & rows, then reset range ActiveSheet Cells SpecialCells xlCellTypeLastCell Row End If RwCnt For Rw Rng Rows count To Step - If Application WorksheetFunction CountA Rng Rows Rw EntireRow Then Rng Rows Rw EntireRow Delete RwCnt RwCnt End If Next Rw Exits Application ScreenUpdating True Application Calculation xlCalculationAutomatic End Sub Sub DeleteBlankColumns Dim Col As Long ColCnt As Long Rng As Range Application ScreenUpdating False Application Calculation xlCalculationManual On Error GoTo Exits If Selection Columns count gt Then Set Rng Selection Else Set Rng Range Columns Columns ActiveSheet Cells SpecialCells xlCellTypeLastCell Column End If ColCnt For Col Rng Columns count To Step - If Application WorksheetFunction CountA Rng Columns Col EntireColumn Then Rng Columns Col EntireColumn Delete ColCnt ColCnt End If Next Col Exits Application ScreenUpdating True Application Calculation xlCalculationAutomatic End Sub However it doesn t work with my current document - pressing CTRL END after running the combined macro takes you to the same last cell as if you hadn t run it Cells in the blank columns and rows at the end have formatting shading cell borders but no obvious data As a test I also tried deleting the contents of column in the middle of the data selecting column and pressing Delete just leaving the cell formatting in place The macro failed to remove that column too So can someone help me get code that actually works in deleting empty columns and rows and resetting the last used cell Ta nbsp

A:Solved: Excel 2003 macro to delete blank columns & rows, then reset range
Relevancy 65.36%

How can I get the row numbers in an Excel worksheet to show and print?

A:Number Excel rows?

File > Page Setup > Sheet, put a check by Print-Row and Column Headings.
Relevancy 65.36%

I want my rows to automatically number beginning with #1, even though the data doesn't start until row 8. What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)

A:Number Rows in Excel

sbudd said:

What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)Click to expand...

=ROW()-7 (Yes)
Relevancy 64.5%


Please can someone help?

I need to repeat all the rows by the number specified in column C.
for example row 2 (Merchant Square) to show 4 times etc


Relevancy 64.5%

I make my taskbar two rows high and I made a toolbar named quot Progs quot containing several folders that contain program shortcuts The toolbar is making poor use of the vertical space available to it using only two rows of folders with the bottom third of it going completely unused The nd row of folders doesn't even line up vertically with control? of to Toolbars Number How - - rows the toolbar name quot Progs quot which is vertically centered and higher than the nd row and the rows don't line up with anything in the system tray notably the clock display which does use rows The icons used in the toolbar are not so Toolbars - Number of rows - How to control? large that only two rows should be displayed and again the bottom third of the toolbar area is empty This is a problem because I have to make the toolbar wider than necessary to avoid the dreaded chevrons which do appear when the system tray resizes to accommodate a transient icon because the toolbar will use only two rows So I'm wondering if is there any way to make the toolbar use three rows

A:Toolbars - Number of rows - How to control?

a picture's worth a thousand words. post a screenshot please
Relevancy 64.5%

Is there a way to print the number of rows of which their value in AG != 0?

I have a spreadsheet with a 'total' column, and I want to find how many rows do not have £0.00 as the result.

Any ideas?


A:Calculating the number of rows which have a certain criteria

It's OK, I sorted it.
In AH5, I put

then filled it all the way down. I then did a sum at the bottom to find the total number of rows.
Relevancy 64.5%

I have 400 records in a 3 column Excel worksheet.

CustName Product Ordered
Jim Bricks 25
Fred Books 357

I need to look at the numbered ordered, insert (numbered ordered - 1) rows and copy CustName and Product into those new rows.

How can I do this easliy?

Relevancy 64.07%

Hi, sometimes when I copy text from MS Word to MS Outlook (Office 2007), instead of copied text is pasted a small icon of envelope with a lock. I'm using Windows 7. Any ideas please?
Additional information:

it happens in the following situations –
1. When copying text to the clipboard from a WinWord doc and pasting to an email.
2. When copying text to the clipboard from an email and pasting to a WinWord doc.
3. When copying text to the clipboard from an email and pasting to another email.

It is happening more than 50% of the time.

A:Copy/paste problem (small icon of envelope is pasted instead of copied text)

How are you doing these Copy and Pasting?

Using the menu, shortcut keys, or right clicking?
Relevancy 64.07%

I encountered the following situation in Word - I had a table whose Alignment was set to Left - I copied some text from a PDF article Adobe Reader that was laid out on columns the line breaks are copied as well such that when you paste the text somewhere is in altered Word pasted line table - of text alignment cells with breaks else you have to manually delete all the line breaks carriage returns yourself - When Word - alignment of pasted text with line breaks is altered in table cells I pasted the text into one of the table s cells the text was automatically alligned Right with the exception of the last line which is actually a paragraph of its own because of the line breaks Other times the different lines i e paragraphs are Centered but never Left aligned as they should be I have to do this operation Word - alignment of pasted text with line breaks is altered in table cells many times and it s irritating enough to have to delete all the unnecessary Word - alignment of pasted text with line breaks is altered in table cells line breaks let alone to also have to reenforce the Left alignment of the pasted text after each Paste operation Word is set up to paste text from other programs by keeping text only so any alignment setting from Adobe Reader should not count If I paste text that doesn t have line breaks in it as a result of -column page layout for example then the pasted text looks fine in the WOrd table i e it is aligned Left as it should be Also if I paste the text with line-breaks outside of a table the default Left alignment is maintained for all lines paragraphs so it s only when I paste into a table cell that the alignment is altered Can anyone suggest why this is happening and how I can get text that has line breaks in it to be pasted in tables without bringing in a different alignment Anticipated thanks nbsp
Relevancy 64.07%

Excel no longer deletes data once it has been cut and pasted. It also no longer allows copying non-adjacent cells; it will let me highlight non adjacent cells and select copy, but when you paste it includes all "inbetween" cells. Also, I notice that now when I copy or cut data, I dont see the line change to the ants like it normally does. Any ideas?

Relevancy 64.07%

I want to be able to choose where my tiles go when placed inside of a group. Notice the screenshot below. I would like the Left4Dead 2 tile and the StarCraft 2 to be placed right below the Batman tile (which would give me only 3 columns but every time I placed them there, then 2 more tiles automatically shift over forcing a forth unwanted column. Is there any way to counteract this so that I can achieve only 3 columns if that's what I desire?

A:Customizing Number of Tile Columns?

Hello BeKure. One possible move is to manipulate tile positions with blank fillers from a tile maker app in the store. ... also in combination with Decor8. I sometimes like to position tiles in a particular place.
Relevancy 63.64%

I am not sure if this is possible, but need to give it a shot. Hopefully someone understands what I mean!

I need to create a workbook with two sheets. On the first sheet are going to be options where someone (not myself) will need to input a number for a quantity of an item. On the second sheet will be rows of specifications for different items. I need to know if there is a formula that will take that number and copy/paste that many of the row that I link it to. I'm thinking I may need a third sheet? Number is input on sheet 1 and linked to sheet 2 where it copies a specific row and then pastes that many rows onto sheet 3?? The most important part of the problem is that it has to copy an entire row (or say 7 cells from a particular row) not just one cell.


Relevancy 63.64%

I am using Win 8.1 x64.
Can anyone please tell me how to change number of rows on it? I want 3 rows in centre of screen.
I did see some tutorials but they said "Only for windows 8". So please guide me through this.

A:How to change number of rows in win 8.1 start screen

Hello Jaskaran,

You could use Option One in the tutorial below to change the number of app rows in Windows 8.1, but only if your screen resolution is set to 1920 X 1200 or above.

Start Screen - Metro Apps - Change Number of Rows in Windows 8

Hope this may help,
Relevancy 63.64%

Can you help me understand how to Concatenate all rows of a bunch of records in one column, but with varying numbers of rows and delineated by a keyword indicating the first row like 'File*#' ? The file here gives an example. Thank you!

A:Add equal number of rows between cell with keyword

Hi, If I understand you perfectly, I see that you are receiving a *.txt file with information, If this is correct I prefer that you upload an attachment with this file (the *.txt file)... for me in this case is easier to read this file and then put the result in Worksheet.

Hernan Torres
Maracaibo, Venezuela
Relevancy 63.64%

Hi everybody,
My laptop's monitor's resolution is 1920x1080, but number of rows in Start Screen is 5, but I wanted to increase it to 6. I searched the forum and found the tutorial which mentioned creating (or changing) Layout_MaximumRowCount in the registry, but it has no effect at all.... (NB. I have tried signing out and back in, and even restarting the computer)

There are two other options in the registry:
which are set to 5. I change them to 6, but after I sign out and sign in, they automatically revert to 5......
Can somebody help me please???

A:Cannot change number of rows in Start Screen.... :((

Hello Farzadmf, and welcome to Eight Forums.

What does it tell you is the max you can use when using OPTION TWO?
Start Screen - Metro Apps - Change Number of Rows in Windows 8
You might see if you may be able to adjust your Start screen's DPI scaling size to see if it will allow you to set 6 rows afterwards.
DPI - Change for Modern UI in Windows 8
Hope this helps some for now,
Relevancy 63.21%

Hello Recently I have upgraded my notebook from Windows Ultimate to Windows Pro and then to Windows Pro with Media Center I number I in of screen? Start How rows maximum change do noticed that the Start screen in Windows shows on my laptop's x display rows of tiles on the Start screen However at home I usually attach an HDMI cable to my laptop and work on FullHD x display Now How do I change maximum number of rows in Start screen? the thing is that the Start screen displays rows of tiles by default I tried changing the Layout MaximumRowCount DWORD value in the registry to but unfortunately my Start screen still displays rows of tiles no matter what I try So does anyone have an idea how can I make the Start screen show only tiles instead of on FullHD The reason I am asking for this is because I got accustomed to how the Start screen looked on my laptop's screen and it is very hard to memorize another layout just for when I work at home P S I also used the tutorial to enlarge things in the Modern environment and it showed tiles instead of but Modern applications looked too big for me I just want fewer rows on the Start screen not bigger rows Thanks in advance

A:How do I change maximum number of rows in Start screen?

Hello Vali, and welcome to Eight Forums.

Unfortunately, that option no longer works in Windows 8.1 since it's directly tied to the screen resolution now.

Currently the only thing that may help is OPTION ONE in the tutorial below to turn off Show more tiles.

Start Screen - Metro Apps - Change Number of Rows in Windows 8


To turn on Make everything on your screen bigger to also reduce how many tiles can display.

"Make everything on your screen bigger" - Turn On or Off

Hope this helps,
Relevancy 63.21%

How to indent Footnote text (between the raised number and the body text) automatically?

I have word 2013, and I would like to insert an indentation 1.5 between the raised number and the text in footnotes (see figure 1)

Figure 1

When I go to "Footnote Text" style, and then paragraph to do the indentation, it moves the number and the text to the right (see figure 2). But I do not want this.

Figure 2
1xxxxxxxxxxxxxxx 2xxxxxxxxxxxxxxx3xxxxxxxxxxxxxxx
If I use the hanging option, it only indents the texts below the first line (see figure 3)

Figure 3

I have gone to "Footnote Reference" style, but the "paragraph" tab is locked. I cannot enter. Can anybody help me how to unlock it? Alternatively, how can I get the results I want (figure 1)

Thanks, M.

A:Indent Footnote text (between the raised number and the body text)?

Create your own style, based on Footnote.
Relevancy 62.78%

I continually use MS Word. I had to install Open Office to get access to one it OO's features. Now, when I paste text from one MS Word document to another MS Word document, the formatting of the original Word doc is changed to Italic Times New Roman when the text is pasted. How do I make pasted text retain the same format as the original text? How do I avoid this kind of problem in the future?

Thank you in advance for your replies.

A:Solved: Open Office Install Makes Pasted Text In MS Word Italic Times New Roman
Relevancy 62.78%

I have a workbook that has about 10 pick lists (drop down boxes) in it. When I paste in my data, the data does not "Select" it's value from a pick list so the data looks like it is in an improper format. How can I have my pasted data, choose that value from the pick list, other than going to ever drop down box, and manually selecting?

A:Solved: Pasted Data Match Pick List Values

A Pick-List is just that a Pick-List, you pick the data, if you paste data in the same place it dows nothing until you click the picklis.

Since I don't know what your sheet looks like I can't offer any alternative options
Relevancy 62.78%

Hello I am looking for copy data based on criteria into a new work sheet and format it at the same time My data is a database dump with thousands upon do data rows to dump new from How add I worksheet data of thousands of records and for my purposes I want to create a semi-refreshing excel dashboard that will show the data I want to extract Basically I am dumping How do I add rows of data to new worksheet from data dump the database to an excel tab but can also access the database so getting to the data is not the problem What I would like to do is get the data based on criteria and add it to an excel worksheet with a row being created based on the successful criteria of the data Basically my data looks like this DATA FILE TAB Data file sample http i stack imgur com HSL o jpgAnd this is what I want the data to end up looking like One thing to keep in mind is that I can't simply populate a worksheet as I need to be able to create new rows once good data has been filtered Formatted Worksheet Formatted Worksheet http i stack imgur com twXGS jpgThanks for your help in advance

A:How do I add rows of data to new worksheet from data dump

I'm not quite sure what kind of help you are asking for. Your subject line asks about "adding rows to a new worksheet" yet you posted an image [2] of data that is apparently sorted in some way and formatted with different font sizes and fill colors. In addition, the 2nd contains data that doesn't even appear in the original data set.What exactly are you asking for help with? Are you asking us to help create that 2nd, formatted sheet or are you asking for help with adding rows to that formatted sheet? I also don't understand this line:with a row being created based on the successful criteria of the data.What does "successful criteria of the data" mean?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Relevancy 62.78%


I am trying to learn rules in altering a macro that has been recorded. I need the following code to execute across columns A-AX, where each column is to be sorted independently of the others. Thank you in advance for your time.

ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("A2"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A2:A21")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
End With
End Sub

Relevancy 62.78%

I am trying to find the minimum number out of a set that has a certain label entered beside it. For example:
Number of OrdersCompany
993 BananaCorp
1200 ZoomZoom
500 Banana Corp
43664 Omletted Way
545 Tomato Inc

I want to find the least amount of orders taken from BananaCorp


A:Excel - Finding the minimum number while comparing two columns

You have two columns, Orders , Company

Orders Company
500 Banana Corp
993 Banana Corp
43664 Omletted Way
545 Tomato Inc
1200 ZoomZoom

SOrt on Company as a first key and Order as a 2nd Key.
for a visible max order per company.
It's a beginning.
Relevancy 62.35%

I am usually savvy about Windows, but this one has me stumped. I have taken on a volunteer project that requires me to add volunteer hours in an Excel Pivot Table. I am having calculation issues which I believe to be caused by a limit on the maximun number of rows. Reading Excel help is just confusing me more. My mentor showed me how to do this once, but I did not take notes and now I am a lost puppy. Given the above information, does anyone have a solution? Thanks for your time.

Relevancy 61.92%

I sure hope someone can provide or direct me to the formula to accomplish the following in Xcel I have a singe sheet consisting of rows of data in columns A person has been maintaining this and we are about to convert it to cvs and install a text file in a CGI Perl program to run on a web site For some unknown reason the person who started and has been maintaining the file has set it up In combine Solved: to Need one into rows columns I multiple multiple column containing Xcel, so that the first Solved: In Xcel, I Need to combine multiple columns containing multiple rows into one column columns contain data that should be all in one column Solved: In Xcel, I Need to combine multiple columns containing multiple rows into one column Here is an example a ham radio call we will say is WW XXX In the first column A row he has entered the prefix quot WW quot in the second column B row he has entered the call district quot quot and in the third column C row he has entered the suffix quot WWW quot I have inserted a blank column quot D quot I can combine for example A B and C with the simple formula A amp B amp C placed in D No problem Now the problem and I m sure you all ready can see it I need to do this with all rows It certainly SEEMS logically that I should be able to accomplish this but durned if I ve been able to do it I have Googled I have Jeeved it you name it I ve tried it I have found some quot close calls quot that almost answer it but not the real answer Obviously I can do this times manually but I d rather find a simpler answer if there is one Blessings to anyone who can provide me with the answer This by the way is for a non-business non-profit amateur radio related web site I have no problem converting the Xcel file to the necessary text Fortunately he didn t use any commas in it Anyone have an idea Thanks much Alabama Ron nbsp

A:Solved: In Xcel, I Need to combine multiple columns containing multiple rows into one column
Relevancy 61.92%


I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.


A:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet
Relevancy 61.06%

I am having trouble figuring out how to split some data into separate columns. I have a column that holds numeric dates (example: 01/01/04) - I would like to use the text to columns tool to split this into 3 columns (example: column 1 "01", column 2 "01", and column 3 "04"). It looks like it should be able to do it from the example grid, but it is not working. Can anyone give me step by step instructions with which boxes to check etc...?

Relevancy 60.63%


I have data that looks something like this; NBHFSeasonDielTidal phaseTidal cycle10WinterDSTH7AutumnNblH6AutumnDblF6AutumnDNTE6WinterESTH
I need to repeat the first row (Winter D ST H) by the number in the first column of the row, (in this case 10) the second row (Autumn N bl H) I need to repeat 7 times etc. Is there a way to do this in excel? I have a lot of data and would not be able to do this manually.

Any help would be appreciated


A:Repeating each rows of text by a certain factor

This didnt display quite as I had planned.

Basically I have 5 columns NBHF, Season, Diel, TidalPhase and TidalCycle.

For row 1 I want to repeat columns 2:5 in row 1 by the integer in row 1 column 1.
For row 2 I want to repeat columns 2:5 in row 2 by the intger in row 2 column 1 etc.

Row 1 reads
10 Winter D ST H

So I would like this on my screen

Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Winter D ST H
Relevancy 60.2%

Word 2003
Trying to set up a two column the left main column is the right small column are $ amounts corresponding to the right text column.

I can not figure out how to get the right column to line up evenly with the left...seems to be a double space in the right column always when I hit return return. Attached jpg shows the issue.

Relevancy 60.2%

I'm pulling data from another database into excel, I have data coming into one column I want to split into to two columns. The second column of data is dropping the leading zeros can anyone tell me how to retain the leading zeros when using the text to column command?

A:Text to Columns command in Excel

There's a way, but I need to know whether you want the resulting column to be treated as text or number. I suspect text, but can't be sure.

Try this little experiment where I want to split after 123
When you go splitting, select the column after the vertical line (it'll turn black), then click on Text option. You will end up with
123 456
123 056
but the stuff ends up as text, so you can't do math on it without conversion.

An alternative would be to insert a ":" or "x" into the strings, and then split on the separator, then remove the separator. However, if numbers result, as they will, your leading zeros will be dropped unless you apply a custom format.
Relevancy 60.2%

Hello, I have data which contains vertical lines I'm trying to remove via "text to columns". The data varies in length so doing the "fixed width" option works by sections. I'm trying to use delimited, yet can't seem to insert the delimiter in the "other" box.

data looks like this: |10030|2009 | |

I'm separating the 10030 from 2009, and as I said the first # can be 5,6 or 4 digits. Is there a way to keyboard code the unicode vertical separator?

Thanks in advance!

Relevancy 60.2%

I have a spreadsheet that has name in cell A1 and ID numbers in another cell O1. O1 has multiple listings seperated by a comma such as 456, 234, 432, etc.

Is there a way to separate out the text in O1 and still include all the other information from the other cells.


A1 Name Joe
B1 Address 123 Main
C1 State WY
D1 Alias .... Other info
O1 ID 456

A2 Name Joe
B2 Address 123 Main
C2 State WY
D2 Alias .... Other info
O2 ID 123

Does this make sense?

Relevancy 60.2%

I wish to use the hidden text feature to produce two versions of a document with a single file. I use MS Word 2010. I have complete rows of text with the "hidden" font attribute. When there is just one row at a time in my table, the document displays and prints fine when the hidden text is set to be hidden, in the Word options. The rows that are meant to be hidden are indeed hidden.

My problem is when I have more than one consecutive row hidden. Then I get blank rows; in fact, one less row than there are rows hidden. If I have two consecutive rows hidden, I get one blank row, if there are three, I get two blank rows, etc.

How can I get rid of those blank rows?

Thanks for your help.
Relevancy 60.2%


My database imports spreadsheets (currently between 1 and 1000 rows) and transfers that data into a temporary table. It then updates the table by changing the date format (only to rows containing that data), and then inserts columns of data from the table into two permanent tables.

I would like to paste text into the same rows in other fields on both tables, mailnly to confirm the date and time of each operation, but also other details. I can't immediately see a way of limiting that to only the rows that have just been updated.

Can anyone else?

A:Access copy text into updated rows

How about doing it at the same time?
Or if the Fields are Null to start with any records that have been added would ahve Null values, you casn use an Update query to to update only Nulls.
Relevancy 59.77%

Hello If this post is in the wrong area please let problem...convert text a string of to Novel columns... me know and I will move it Also if anyone can help and needs a sample of the Novel problem...convert a string of text to columns... spreadsheet let me know and I will post it I have a large database that is coded in MS Access One of the fields that we need to do an analysis on Novel problem...convert a string of text to columns... is selected in the database as a lookup list It is stored as text in the dbase When an excel spreadsheet is exported with this data one of the fields called ShortHandNotes contains all of the text items from the original database in alphabetical order For example ShortHandNotes Column Name in Excel Ant Capsular fibriosis see notes Chop Dense Maloney RB in OR see notes Vannas see notes VB Now the delimiter between the text items is a semicolon I know how to use the neat function in excel quot Text-to-columns quot to separate these items into columns Here is where the problem lies I need to get each of the text items in the above list for example Chop into a column named quot Chop quot The issue is that every record of them could have a variable amount of shorthand notes For example another record could be like this Dense FIS Maloney Small Pupil VB Viscodilate The only commonality between these lists is that there is finite amount of notes I think there are only possible shorthand text items and that they are alphabetical So right now I would have to extract the text to each column and then create new columns for each of the text items FIS Dense Chop etc and then sort each of the newly made columns alphabetically and then manually move over a chunk of data that matches Question is there a better way to do this It could actually take weeks or so to move each of these items over in blocks and there is a high possibility that a mistake could be made modifying each record The data to be analyzed is ultimately going to be binarized for medical research so the fidelity of the data is of paramount importance For example Dense FIS Maloney Small Pupil VB Viscodilate Would be extracted to columns named quot Dense quot quot FIS quot quot Maloney quot quot Small Pupil quot quot VB quot quot Viscodilate quot I would then globally search and replace each of the text fields in that column and flag them with a if blank it would be In this way I can then do a logistic regression to test for these indicators Any help anyone can provide would be appreciated Thanks in advance Jaysen nbsp
Relevancy 59.77%

Hello I am working on a project for grad school and thought I 2007 only Excel in columns containing Analyzing text would see if anyone can help me I am analyzing population data from a census and it revolves around surnames and Analyzing columns containing text only in Excel 2007 their frequency I ve attached a small sample file showing what I am dealing with Real files I use have thousands and thousands of entries My job is to take each location and figure out which surnames appear in it and Analyzing columns containing text only in Excel 2007 how many times Now the job is made slightly easier by sorting them alphabetically but it is still very time consuming I was thinking that since the surname is always the first word in its column there might be a way to let Excel analyze the column and give me the summary Tell me there are rows that begin with Smith with Rietke with Langley and with Johnson Now I am somewhat familiar with Excel s Analyzing columns containing text only in Excel 2007 ability to analyze numerical data the whatifs the pivot tables etc However I have not been able to think of a way to have it to this The chief problem is that whereas I know how to get Excel to tell me how many instances of a known word appear in the sheet I have no idea how to do it with unknown ones If I simply had to look for surnames I knew it would be easy but when I open a sheet for the first time I have no idea what surnames to count Therefore I cannot use any of the whatifs because I do not know the quot ifs quot I just know there are many surnames and I as things stand now write them down and count their appearances by hand Can someone help Is what I m asking even possible or are we talking about something that would require programming Thank you in advance nbsp

A:Analyzing columns containing text only in Excel 2007

Good morning, welcome to the fourm,
Maybe not exactly your need, but you could try the list option.
I know where to find it in Excel 2003.
I applied it to your sample.
If you right click on the header column D (Name) you see text fileter, and you can choose starts with or begins with.
say you enter Smith,

You will see all the names beginning with Smith.

What you would really need a an extra smeet with a list of uniwue surnames and a macro or vlookup or similar to have it count how many Smith, Rietke etc and place the value beside it.

This is for starters.
Relevancy 59.77%

If I have data in excel that needs to be separated into columns that looks like this:18SampleStreetBIGTOWN18SampleLittleStreetLITTLETOWNWith the data wanting to look like:18 Sample Street BIGTOWN18 Sample Little Street LITTLETOWNIs there a way to separate the town which is all in Capitals?ThanksRobynmessage edited by Robyn69
Relevancy 58.91%


When I scan a document with, let's say an three inch column. It is saved with that width and if I want to work with it in Word I have to manually delete carriage returns to make the text lines full width.

Is there an easier way to do this?

Sorry if my question is vague; I have virtually no Word experience.