+ Reply to Thread
Results 1 to 3 of 3

Cell references inside a big text

  1. #1
    Registered User
    Join Date
    06-13-2022
    Location
    Athens
    MS-Off Ver
    365
    Posts
    2

    Cell references inside a big text

    Hello, I have a large amount of text which I want to recycle hundreds of times for a retailer store. I want to change only key characteristics of the product. For example if I have to create the text for one hundrend laptops I want to change only specific parts of the text such as CPU model, GPU model etc. I found a way to do it but it is not suitable for large texts because there is a text limit of 255 characters and I have to use &" again and again.

    For example

    The ThinkBook 16p Gen 2 was a rather popular 16 inch laptop based on the AMD Ryzen 5000H series platform. It coupled those powerful chips with the Nvidia GeForce RTX 3060, making it a gaming-ready multimedia device"...

    ="The ThinkBook 16p Gen 2 was a rather popular 16 inch laptop based on the" &A1 &"series platform. It coupled those powerful chips with the Nvidia GeForce RTX 3060, making it a gaming-ready multimedia device"...
    A1 is the cell that has the cpu model for example

    Is there any otherway to do the same thing but without a text limit and not so restrictive so I can use it in more complicated texts. Thanks a lot

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Cell references inside a big text

    my thoughts would be to utilize TEXTJOIN() function. This string can handle 32,767 characters and 252 arguments.
    see example workbook and see if that works for you.
    Attached Files Attached Files
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Registered User
    Join Date
    06-13-2022
    Location
    Athens
    MS-Off Ver
    365
    Posts
    2

    Re: Cell references inside a big text

    Thanks a lot that's what I was looking for, really appreciate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert date text inside a cell into DATE() type inside a function
    By xChristy in forum Excel General
    Replies: 4
    Last Post: 06-04-2020, 09:44 AM
  2. [SOLVED] Use activecell inside another cell text
    By Rui Farinha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2017, 06:12 AM
  3. [SOLVED] Changing Cell References inside INDIRECT function.
    By Zox Tomana in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2016, 12:36 AM
  4. [SOLVED] Increment Cell references inside of an IF Formula
    By Feicstur in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2015, 01:43 PM
  5. [SOLVED] searching inside cell text
    By sherif in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-01-2013, 10:36 PM
  6. Cell References inside a LINK
    By karaflas01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2008, 11:03 AM
  7. Evaluating References inside Formulas
    By Stevo2k5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2007, 05:13 PM

Tags for this Thread

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