Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How to insert from name range into a paragraph?

I am trying to insert a name from a range to a text in excel. I inserted a
name range "Our_Entity" from another tab to the below etxt but ot does not
work.
--------------------------
Per agreement between Our_Entity and LEGAL_LINE_3 .............

I used , and " before and after ranges but did not work.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default How to insert from name range into a paragraph?

you have to use a formula, I'm guessing LEGAL_LINE_3 is also a name:

="Per agreement between " & Our_Entity & " and " & LEGAL_LINE_3

"misterno" wrote:

I am trying to insert a name from a range to a text in excel. I inserted a
name range "Our_Entity" from another tab to the below etxt but ot does not
work.
--------------------------
Per agreement between Our_Entity and LEGAL_LINE_3 .............

I used , and " before and after ranges but did not work.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How to insert from name range into a paragraph?

Thanks Esteban

But now my names referenced as dates not working. It reads like this

Company, LLC dated 37681 is requested

but it is formatted as =Company, LLC dated "&Dated_As_Of&"

where Dates_As_of is mapped to 03/05/06 in dated format but it turns into
37681

Thanks

"Esteban" wrote:

you have to use a formula, I'm guessing LEGAL_LINE_3 is also a name:

="Per agreement between " & Our_Entity & " and " & LEGAL_LINE_3

"misterno" wrote:

I am trying to insert a name from a range to a text in excel. I inserted a
name range "Our_Entity" from another tab to the below etxt but ot does not
work.
--------------------------
Per agreement between Our_Entity and LEGAL_LINE_3 .............

I used , and " before and after ranges but did not work.

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
insert a paragraph break within text in a singel cell? Julie Excel Discussion (Misc queries) 4 April 5th 23 02:44 PM
how can i insert a subtotal from a range of dates rosa Excel Worksheet Functions 1 May 24th 06 06:58 PM
HOW CAN I INSERT A SUBTOTAL FROM A RANGE OF DATES rosa Excel Worksheet Functions 0 May 24th 06 05:47 PM
Auto insert a range fastballfreddy Excel Discussion (Misc queries) 1 May 9th 06 12:41 AM
Insert...Name Range childofthe1980s Excel Discussion (Misc queries) 1 May 24th 05 03:52 PM


All times are GMT +1. The time now is 06:25 PM.

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"