to view a column text in another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have 5 columns is a spreadsheet what I want to be able to do is if in
column A I enter any text the I want column D to be automatically up dated to
show the same text as column A. What is the best way to do this?
 
The simplest way:
in cell D1 enter =A1 and copy D1 down as far as desired. This will
make column D the same as Col A.

Since you mentioned text, it may be that you only want Col D to equal Col A
if Col A has text. If so, in D1 enter =If(IsText(A1),A1,""). Again
copy down col D
This will leave Col D blank in A is numeric, an error or blank

If you want a vba solution, let us know
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Remove specific cells in a column. 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
merging multple columns into one column (dynamically) 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Excel Subtracting multiple columns from another column 3
VBA Conditional formating for specific text in several columns 1
Paste in column B using Last row of either column B, C or D. 10

Back
Top