Thread: Automate Merge
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Automate Merge

You inadvertently introduced an error for the formulas in col E
In E2 down, you had: =IF(C3="",D2&" "&D3," ")

It should have been in E2 down:
=IF(C3="",D2&" "&D3,"")
The false return should be a null string: "", not a single space

Once you correct the above, col F will return correctly
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote:
Max,
Direct Link: http://www.freefilehosting.net/download/3bed9
Let me know when you get the file.
John