De-concatenate in Excel?? 1

[tazman99]

Hello everyone, how do you De-concatenate in Excel97?? For example,
In cell A3, I have Last Name, First Name and in the end I want it to be First Name Last Name in cell A3

Thanks everyone in advance!!
Andrea

 

[DaleWatson123321]

Hi Andrea,

The following formula will work...

=MID(A3,FIND(" ",A3,1)+1,999)&" "&LEFT(A3,FIND(" ",A3,1)-2)

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[tazman99]

Thank You Dale, it worked flawlessly!! I knew you and Tek-tips would take care of me! Have a good weekend!

Andrea

 

[DaleWatson123321]

Andrea,

I'm pleased that you appreciated my formula, and thanks for the STAR.

However, in re-assessing the situation, I realized that I should have written the formula to search for the "comma" instead of a "space".

The reason - to allow for those last names which consist or two or more words. For example Dutch last names and Hispanic last names... such as
"Van Hengel, Wilhelm", or "De Sousa, Roberto"

The following formula is therefore a better solution...

=MID(A3,FIND(",",A3,1)+2,999)&" "&LEFT(A3,FIND(",",A3,1)-1)

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca