+ Reply to Thread
Results 1 to 2 of 2

Converting linked text to text

  1. #1
    Registered User
    Join Date
    11-18-2021
    Location
    Yorkshire
    MS-Off Ver
    Windows 10
    Posts
    1

    Converting linked text to text

    I have a sheet with the information linked from other sheets and documents, eg using ='Q52 Equipment'!A568
    How can I embed the text from the linked cell, and lose the link?
    Thanks,

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Converting linked text to text

    Highlight the cell, Press Ctrl+C to copy it and then either use "Paste Values" from the paste menu. Using keyboard only, you should be able to do:

    Ctrl+C
    Ctrl+V
    Ctrl
    V

    That should paste value and lose the link.

    WBD
    Office 365 on Windows 11, looking for rep!

+ 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] Linked text from another sheet if a certain text exists
    By skylinekiller in forum Excel General
    Replies: 5
    Last Post: 11-19-2018, 06:39 PM
  2. [SOLVED] Converting string containing numbers and text to currency and text
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2016, 05:05 AM
  3. [SOLVED] Sum two cells where one has text with values linked to that text
    By loki316 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2015, 03:00 PM
  4. Replies: 2
    Last Post: 10-16-2014, 05:45 AM
  5. Converting linked workbook data to text
    By ajmjr24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2014, 10:21 AM
  6. Remove quotes in text file after converting Excel to Text in VBA Access 2002
    By ucalcen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 10:35 AM
  7. Replies: 0
    Last Post: 01-30-2013, 07:05 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