Text to columns at last space only

**mieuxvivre** · 05-07-2013, 07:22 AM

I have a column that has multiple words, mostly names. I need to split them into two columns at the last space.

Examples:

Please Login or Register  to view this content.

I need to have the names split as follows.

Please Login or Register  to view this content.

My name column is currently starting at B2. I have seen instructions how to split at first space or how to split into First, Last and Middle names but I only need to split at the last space. Thanks in advance for your help.

**martindwilson** · 05-07-2013, 07:40 AM

put
=TRIM(LEFT(SUBSTITUTE(B2," ",REPT(" ",25)),LEN(SUBSTITUTE(B2," ",REPT(" ",25)))-25)) in c2 and
=TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",25)),25)) in d2

**Kevin UK** · 05-07-2013, 08:13 AM

Hi mieuxvivre

Try the following.
In D2:

Formula:

Please Login or Register  to view this content.

Then in C2:

Formula:

Please Login or Register  to view this content.

**im.zeeshan** · 05-07-2013, 08:45 AM

I'm assuming you have placed all the Full Names in Column A starting from Row 2.

Once you have done that, run the following macro:

Please Login or Register  to view this content.

Text to columns at last space only

LinkBack

Thread Tools

Rate This Thread

Display

Text to columns at last space only

Re: Text to columns at last space only

Re: Text to columns at last space only

Re: Text to columns at last space only

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions