 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Text verify and transfer to another cell
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...  Signaturejgbadingerjr Try this in cell F2: =IF(A2="","",A2) Whatever is entered into A2 will also appear in F2. Hope this helps. Pete > 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... >Try this in cell F2: > [quoted text clipped - 5 lines] > >Pete How would that differ from merely: F2: =A2 ??? --ron > 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) SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) >>Try this in cell F2: >> [quoted text clipped - 13 lines] > > --ron >> How would that differ from merely: >> F2: =A2 [quoted text clipped - 3 lines] >=A2 returns 0 >=IF(A2="","",A2) returns an empty string (cell appears empty) Duh. Of course. Thanks. --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.