Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22
Default Is it possible to use a formula in the middle of a sentence in exc

If so, how?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,934
Default Is it possible to use a formula in the middle of a sentence in exc

Your question would be clearer if you wrote it in the body of the message,
added more detail explaining what you were looking to accomplish and
provided an example or two that showed what you were trying to do. I'll take
a guess that this might be what you are looking for...

="Some text"&<YourFormula&"and some more text"

For example, something like this example maybe (where I'm assuming Column A
contains a list of names)...

="There are "&COUNTA(A1:A100)&" people on the list"

--
Rick (MVP - Excel)


"krissy" wrote in message
...
If so, how?


Reply
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
Using a formula in a sentence krissy Excel Discussion (Misc queries) 5 February 25th 10 04:55 AM
I need to round in the middle of a formula Simon Excel Discussion (Misc queries) 1 August 16th 09 12:01 AM
how do i insert roman numberals in the middle of a sentence kay Excel Worksheet Functions 1 February 19th 09 10:02 PM
Diff colours in same sentence inc a formula bookman3 Excel Discussion (Misc queries) 1 June 21st 07 02:18 AM
Any formula to shorten sentence to a specific length supercloudbug Excel Worksheet Functions 5 April 15th 05 02:13 AM


All times are GMT +1. The time now is 05:31 PM.

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

About Us

"It's about Microsoft Excel"