Getting text to appear in another sheet

  • Thread starter Thread starter thomasbrandon
  • Start date Start date
T

thomasbrandon

I'm working with two worksheets: Sheet 1 and Sheet 2 (I'll call the
this for simplicity). I want to get the data (text) in Sheet 1 int
Sheet 2.

I know how to do this using =Sheet1!C1 (etc.)

However, not all the "C" cells in Sheet 1 have text. I only want tex
to appear in Sheet 2 (cell "A") when there is actually text in the "C
cell of Sheet 1. Is there anyway of doing this without getting th
default "0" that it puts in when there is no text.

As I read this it sounds like a tounge twister, but hopefully someon
can help as my Excel skills only go so far.

Thanks so much!

Brando
 
Hi,

There are few possibilities. You can for example change your formula like
=IF(Sheet1!C1<>"";Sheet1!C1;"") or you can customize the format in target
cells like ;;;@ (or it might be ,,,@ in US).

There are also some other ways to do that.

- Asser
 
Back
Top