LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Concatenate formula or &

I am creating a text template in excel and I have the following 2
rows(combination of text, number and formula and %). please note that I
changed the format of E1 to percentage with 2 decimal.
To combine the following cells together:

A1 | B1 | C1| D1 | E1 | F1
2 | Divided by | 3 | is | =(A1/C1) | percent

i created this formula in cell A2:
=A1&B1&C1&D1&E1&F1

and i get:
2 Divided by 3 is: .666666666666 percent

and i want to get the following in one cell:
2 Divided by 3 is: 66.66% percent

what should i do?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with formating % in concatenate formula Outapin Excel Discussion (Misc queries) 7 December 2nd 05 02:52 PM
I can't get my concatenate formula results to show Lauren Excel Discussion (Misc queries) 3 November 18th 05 04:55 PM
Can I concatenate text in cells to make a working formula? Matt S. R. Excel Discussion (Misc queries) 11 November 11th 05 03:44 PM
Evaluating results of a concatenate formula, as a formula dodger Excel Worksheet Functions 5 September 9th 05 01:55 PM
CONCATENATE formula jkeeton Excel Discussion (Misc queries) 1 April 1st 05 05:33 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"