General Cell Data Verification and Copy...

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

Guest

I am looking for the function or combination of functions to do the
following...

If cell A2 has no data in it (General Data) then cell F2 reflects the same
(blank), however if cell A2 has some data in it for Ex: N 90-00-00 W the cell
F2 would reflect this as well...I work great with numbers but text and text
strings confuse me...

Thank you,
 
In F2 put this formula:
=If(A2="","",A2)
This formula does as follows:
If A2 is blank, F2 displays as blank.
If A2 is not blank, F2 displays the contents of A2. HTH Otto
 
You might try a formula like the following in F2
=IF(ISBLANK(A2),"",A2)
 
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

Text verify and transfer to another cell 4
If formula and Data Validation parallely 1
b;ank cells in calculations 2
array question 2
Copy formula where the cell refrence is not sequential 1
Referencing a cell. 1
copy data from one worksheet and disregard blank cells 6
Excel 0 and Blank fields. 1

Back
Top