Text verify and transfer to another cell

[Guest]

I need a function to check a cell for text (general data) and if it exists in
one cell transfer (copy) to another cell...for example cell A2 is blank so
the cell F2 is also blank, however if A2 has data in it say N 90-00-00 W then
the same would be reflected in cell F2... I'm great with number conversions
and computations but text strings and general data baffle me.
Thank you for your efforts...

 

[Pete_UK]

Try this in cell F2:

=IF(A2="","",A2)

Whatever is entered into A2 will also appear in F2.

Hope this helps.

Pete

 

[Ron Rosenfeld]

Try this in cell F2:

=IF(A2="","",A2)

Whatever is entered into A2 will also appear in F2.

Hope this helps.

Pete

How would that differ from merely:

F2: =A2

???


--ron

 

[Chip Pearson]

How would that differ from merely:

F2: =A2

The difference comes into play when A2 is empty.

=A2 returns 0
=IF(A2="","",A2) returns an empty string (cell appears empty)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Ron Rosenfeld]

The difference comes into play when A2 is empty.

=A2 returns 0
=IF(A2="","",A2) returns an empty string (cell appears empty)

Duh.

Of course.

Thanks.
--ron