Results 1 to 6 of 6

Inserting named ranges in wall of text with quotation marks issue

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2017
    Location
    London
    MS-Off Ver
    2013
    Posts
    12

    Inserting named ranges in wall of text with quotation marks issue

    Hi guys

    Im trying to create an automated disclaimer page which is locked with a standard message (so that this file can then be used as a template by our team). It references the client company name and abbreviation (via a named range). It also references my firms full name with an abbreviation in brackets with quotation marks.

    The issue im getting is

    1) i cant get quotation marks around the client company names abbreviation (derived from named range).
    2) i keep getting error if i put quotation marks around my company's abbreviation (although not when i put them around a different word e.g. "Model").

    The desired output is as follows:

    This financial model ("Model") was built for a specific purpose by My Firm ("ABC") for ABC's client, Company Name ("Abbreviation") and ......(remaining text)

    What i have so far is:

    ="This financial model (“Model”) was built for a specific purpose by My Firm (ABC) for ABC’s client, " & CoName & " (" & CoAbb & ") text."

    The above however keeps giving me error when i put ("ABC") and I cant figure out what the change should be to the last bit so that client abbreviation has " i.e: ("Abbreviation") rather than just (Abbreviation).

    CoName and CoAbb are the named ranges for Client Company Name and Client Company Name abbreviation.

    I understand that putting quotation marks in the abbreviation named range would probably be the easy fix but id be using that named range for other purposes where i wouldnt want them.

    Any help would be greatly appreciated.

    Many thanks
    Attached Files Attached Files
    Last edited by ExcellingOcfUpsides; 10-29-2019 at 09:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Quotation marks on select text in cell
    By UpNorthDigital in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2017, 02:50 AM
  2. [SOLVED] Inserting quotation marks into VBA code
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2014, 10:13 AM
  3. [SOLVED] CONCATENATE text that includes quotation marks
    By spoonpilot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2012, 04:13 PM
  4. inserting a formula with VBA that has quotation marks
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2010, 06:11 PM
  5. Inserting Quotation Marks in all Cells
    By confused in forum Excel General
    Replies: 4
    Last Post: 10-19-2005, 09:05 AM
  6. [SOLVED] inserting quotation marks
    By dave glynn in forum Excel General
    Replies: 2
    Last Post: 06-17-2005, 05:05 AM
  7. [SOLVED] How do I concatenate text that actually contains quotation marks?
    By Excel Distress in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1