OK - data is usually :-

1. manually entered, a person types a row of new data or

2. formula extracted, a person types in column B and a formula
extracts a portion of that data to column D (ie, =Left(b1,6)) or
(=b1*C1) where B1 contains a quantity and C1 contains a rate etc
or

3. data is imported, usually in the form of a .csv (comma delimited)
file, or a text (tab or space delimited) file, and the import function
(or Text-To-Columns function) separates the data across columns.


How was your data in column B derived, and why do you think there
should be data in column D ?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385040