+ Reply to Thread
Results 1 to 3 of 3

Function to copy text from one cell to another

  1. #1
    Registered User
    Join Date
    04-03-2008
    Posts
    14

    Function to copy text from one cell to another

    I'm sorry if I'm just thick, but I can't find any function to automatically insert text from one cell into another. I don't want to do anything to the text, just automatically copy the text in one cell into another. This seems as if it would be so simple, but I can't work out how to do it. I have made sure that both cells - the target and the original are formatted as text, and I have looked through all the text related functions listed under "Insert > Function", but I haven't had any luck. I am using Excel 2003 & Windows XP Home SP2.

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,579
    Couldn't you just use =A1?

    If A1 had your text, and you wanted to "insert" the text from A1 to C7, then in C7 type the formula, =A1

    Whenever you change A1, C7 will also update.

  3. #3
    Registered User
    Join Date
    04-03-2008
    Posts
    14

    I tried that

    Thankyou for that - I have finally got it to work. However, I have found that it doesn't work if the cells are formatted as "Text", which seems really wierd. It works for other formatting, but not "Text".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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