# Copy cell from one sheet to another sheet with text in it

#### Phixtit

##### Active Member
I have a cell on sheet1!A1 that user can enter the text:
"C", "O", "S", "T", or "X"
I have another sheet2!A1 that copies the Text IF entered from sheet1!A1.

The formula I have in sheet2!A1 is:
=IF(sheet1!A1,sheet1!A1,"")

I have all cells formatted as General.

PROBLEM:
I get the following error on sheet2!A1 when sheet1!A1 has Text in it:
#VALUE

any ideas?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### VoG

##### Legend
Try

=IF(Sheet1!A1<>"",Sheet1!A1,"")

Solved!

Thanks!

Replies
17
Views
665
Replies
3
Views
327
Replies
4
Views
775
Replies
2
Views
220
Replies
6
Views
496

1,190,913
Messages
5,983,532
Members
439,848
Latest member
timmyo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back