First initial + Last Name in external imported data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNT rows on external sheet if between date range 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Moving data from CSV to Excel sheet 1
Import external data 6
Create a new sheet dependant on values 1
Easily mailing list from Data File 3

Back
Top