Trim cell contents

  • Thread starter Thread starter Kim C via OfficeKB.com
  • Start date Start date
K

Kim C via OfficeKB.com

I have a long list of names in Excel where the first and last name are in one
cell. I want to split the names with first name in one cell and last name in
another cell. I know how to use the "Left" and "right" functions but then I
have to use a different formula for each name since each name is a different
length. Is there an easier way to do this?
 
Hi Kim,

Try this:

=LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1)

and

=MID(TRIM(A1),FIND(" ",TRIM(A1))+1,LEN(TRIM(A1)))

Regards,
KL
 
You must log in or register to reply here.

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

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel help separating / 2
Splitting Text from single cell in column across multiple Columns 3
Seperating information in a cell 9
Update cell value based on name and specific date 1
Vlookup and return sheet name also 2
VBA set thick borders around non empty cells in range 0

Back
Top