Clay Icon

Workaround for Large Text in Spreadsheet Cells

Β·
Β·

If the text is large, it does not fit into the cell. What is the workaround?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    πŸ’€ You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Tanvi R.
    Tanvi R.
    Β·
    Β·

    Hi Ateet, thanks for reaching out! You are correct there is a cell size limit of 8000 characters that cannot be exceeded. Could you tell me where the data is coming from and what you're trying to achieve? There are a few workarounds depending on this answer. For example, you could consider splitting the data across multiple columns or rows or use a formula to process and summarize the data to fit within the character limit. Please let me know and I'd be happy to assist you further!

  • Avatar of Ateet S.
    Ateet S.
    Β·
    Β·

    Find People LinkedIn description value

  • Avatar of Bo (.
    Bo (.
    Β·
    Β·

    Thank you for pointing that out! 😊 Have you tried doing it with a formula column? Here’s how you can set it up: 1. Create a formula column with the prompt for the first part: β€’ Extract the first 4000 characters from the /description column. 2. Create another formula column for the last part: β€’ Extract the last 4000 characters from the /description column. Make sure to link the /description column correctly using the forward slash. Let me know if this helps! 😊

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hi Ateet S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: