Text verify and transfer to another cell

J

jgbadingerjr

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...
 
P

Pete_UK

Try this in cell F2:

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

Whatever is entered into A2 will also appear in F2.

Hope this helps.

Pete
 
R

Ron Rosenfeld

Try this in cell F2:

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

Whatever is entered into A2 will also appear in F2.

Hope this helps.

Pete
Click to expand...


How would that differ from merely:

F2: =A2

???


--ron
 
C

Chip Pearson

How would that differ from merely:
F2: =A2
Click to expand...

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)
 
R

Ron Rosenfeld

The difference comes into play when A2 is empty.

=A2 returns 0
=IF(A2="","",A2) returns an empty string (cell appears empty)
Click to expand...


Duh.

Of course.

Thanks.
--ron
 
Top