Using concatenate in Excel will bring things together. Is there a way
to do the opposite of that?

I have one sheet that has John Smith listed for the buyers name. I
have another sheet that lists all my buyers but I don't need John's
full name listed for this purpose. His first name would do. Without
going back and making changes in my sheets with all the names, can I
do anything to have it just take the first name?

Example:
Sheet 1 NAME ADDRESS PHONE etc
John Smith 123 Main St 555-1212


Sheet 2 NAME
='Sheet1'!A4 <----- that's what I'm currently doing
with the end result saying "John Smith"


I hope this makes sense.

Thank you.

Chip