Dealing with Text in a Function cell

=?Utf-8?B?S2FyZW4=?=

Guest

Posts: n/a

18th Sep 2006

I have 2 spreadsheets in one workbook that contain some of the same data.
I've used the following function to poplutate the data entered into one
spreadsheet into the other with the same data:
=IF('Reg Doc Tracking'!H2,'Reg Doc Tracking'!H2,"")

It works fine with any dates that are entered but I run into a problem when
I have text in the Reg Doc Tracking H2 cell. I need to be able to enter a
date or text into the field and have it populate into the other spreadsheet
that contains the same data.

I'm working with Excel 2003.

Thank,
Karen

« use formatting from source cell in CONCATENATE function | use formatting from source cell in CONCATENATE function »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dealing with Text in a Function cell	=?Utf-8?B?S2FyZW4=?=	Microsoft Excel Worksheet Functions	6	20th Sep 2006 02:24 AM
function dealing with data after screen refreshing	thread	Microsoft Access	0	14th Aug 2006 12:50 PM
Dealing with a Locked Cell	Craig	Microsoft Excel Programming	2	7th Sep 2005 02:20 PM
dealing with cell text limits	Walter Harley	Microsoft Excel Misc	3	5th Mar 2005 04:42 PM
Dealing with NULL values - NZ function	Joe Williams	Microsoft Access Queries	1	2nd Sep 2004 04:12 PM