How can I take rows of data and insert two lines between them. See example below:
Looks like this:
A B
1 234 at
2 342 be
3 125 ant
4 782 deal
5 572 field
Needs to look like this:
A B
1 234 at
2
3
4 342 be
5
6
7...
CAN SOMEONE HELP ME CREATE A FORM IN EXCEL XP. I HAVE A SPREADSHEET THAT HAS A TEAM NAME, DEPOSIT AMOUNT (10 DIFFERENT COLUMNS FOR INDIVIDUAL DEPOSITS), DEPOSIT DATE (10 COLUMNS TO MATCH UP WITH THE DEPOSITS), DEPOSITED TO (10 COLUMNS TO MATCH WITH DEPOSITS, DEPOSIT DATE),REG FEE (1 COLUMN)...
Everytime I open Excel, every cell on every page(workbook) is dividing what ever number or character I put in there by 100. I have tried formatting it and that doesn't work. Any suggestions?
Is there a max width the column can be in excel. I have a worksheet and it has a column width of 69.71 and will not open anymore unless I double click....the row height is 165.75. There is more text in the field but if you widen it then close the worksheet when you open it back up you can not...
Why would a text file export from diskette into Access ok but when you try to export it from Access to Excel the data will not all export. You can break it into sections and export but can't send it as one export. The field sizes are not large. How can you tell if the data on the disk is...
I have a database that has one table with Vendor Information and the other with Account Number information. When I create a query it only returns half the information (either the Vendor information or the account number information but not both). All the headers from both table will show but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.