Getting text to appear in another sheet

[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

 

[AH]

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