View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill Nick Krill is offline
external usenet poster
 
Posts: 19
Default First initial + Last Name in external imported data

I've created a "Report" sheet that picks data from a "Data" sheet in the same
xls file. The "Data" sheet uses "Import External Data" from a CSV file dumped
from MLS data.

On my report sheet how can I create a column of first initial + space + last
name from column DK on the "Data" sheet which = First+Space+Last names as
imported from the CSV file??