» Combining Text and Formatted Values
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
1. In cell A1, enter the text IBM owe Limelight Media Inc.
2. In cell A2, enter the number 4222.
3. In cell A3, enter the text for services supplied in March 2004.
4. In cell A5, enter the formula:
=A1&" "& TEXT(A2,"$ #,##0") &" "&A3
To format the number to present it in thousands:
Change the number format to "$ #, K":
=A1&" "& TEXT(A2,"$#, K") &" "&A3
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The 22 Immutable Laws of Branding
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Investing in Real Estate, Fourth Edition
- The Basics of Finance: Financial Tools for Non Financial Managers
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
Merge sheets
sudhir Posted on: 31-12-1969
I hv 50 sheets in one file which has to be merged in one sheet, is there any formula to copy all sheets in one sheet?Reply: Merge sheets - sudhir from mumbai wrote on August 9, 2003 6:34 AM EST
Alan Posted on: 31-12-1969
Hi Sudhir,
I doubt there will be a simple answer to this one.
Please can you give some samples so that we have a better idea of what you want to achieve.
Thanks,
Alan
Merge all sheets in one sheet
Sudhir Posted on: 31-12-1969
i hv data in sheet1 from A1 to A3000 as mentioned below :
"Client Name" "Brand Name" "Bill No." "Bill Date""Bill Amt."
There are 50 to 60 sheets where columns are same but the data are different, now i hv to merge all sheets in one column, is there any formula? I hv tried "consolidate" formula in data menu but the problem is, it will only takes the total & other but i can't copy all text in one sheet? Could u pls help me?
Awaiting ur early reply
Thanx & Regards,
Reply: Merge all sheets in one sheet - Sudhir from Mumbai wrote on August 11, 2003 12:10 AM EST
Alan Posted on: 31-12-1969
Hi Sudhir,
Sounds like a one off thing that you will never need to replicate?
If so, to be honest, I suggest you do it manually.
With 50 to 60 sheets, I cannot imagine it will take more than an hour or so, and you could easily spend that long trying to write a macro or formulae that would do it for you.
Is that practical?
Alan.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
