First initial + Last Name in external imported data
On your report sheet, assuming name of sheet importing data is "Data" put
this formula where you want shortened name to show up:
=LEFT('Data'!DK1,1) & " " & RIGHT('Data'!DK1,LEN('Data'!DK1)-FIND("
",'Data'!DK1))
This will work as long as format on the Data sheet is as you described, a
middle name or initial would mess it up. Change "DK1" to whatever row your
information starts on on the Data sheet.
"Nick Krill" wrote:
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??
|