Extracting Name from Cell with Date and Name Data

[Jessrozy11]

Hi,

I have a cell that has date and name (last name, first name):

01/27/2019-Gxxxxxxx, Txxxxx

01/26/2019-Kxxxxxxx, Exxx

01/02/2019-Mxxxx, Axxxxxxx

01/27/2019-Gxxxxxxx, Txxxxx

<tbody>
</tbody>

I need to remove the date and only see the name and preferably in the opposite order. Right now it is showing last name, first name. Prefer first name last name.

I'd like to see data as:
Txxxxx Gxxxxxxx
Exxx Kxxxxxxx
Axxxxxxx Mxxxx
Txxxxx Gxxxxxxx

I tried =MID($A2, 12, 30) but I’m worried the date format may come through as 01/2/2019 for the single digit days. I also wasn’t able to figure out how to switch the name order either. Is there an easier way or different formula I can use?

Greatly appreciated!
Jessica

 

[Joe4]

Adding the TRIM function didn't work but I think I'll be ok. This was great assistance! Thank you all!

You may have some special characters in there, like non-breaking spaces or other things that the TRIM function does not work on.
That is very common with data that comes from other sources (especially the web).

 

[jtakw]

Hi,

Try and see if this works for you, will remove "non-breaking" and normal spaces:

Book1
	A	B
1	01/27/2019-Gxxxxxxx, Txxxxx	Txxxxx Gxxxxxxx
2	01/26/2019-Kxxxxxxx, Exxx	Exxx Kxxxxxxx
3	01/02/2019-Mxxxx, Axxxxxxx	Axxxxxxx Mxxxx
4	01/27/2019-Gxxxxxxx, Txxxxx	Txxxxx Gxxxxxxx
Sheet621

Cell Formulas
Range	Formula
B1	=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(MID(A1,FIND(",",A1)+1,99)&" "&MID(A1,FIND("-",A1)+1,99),CHAR(160)," "),",",REPT(" ",99)),99))

 

[Jessrozy11]

Using the following code solved my spacing issue. Thank you!

=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(MID(A1,FIND(",",A1)+1,99)&" "&MID(A1,FIND("-",A1)+1,99),CHAR(160)," "),",",REPT(" ",99)),99))

 

[jtakw]

You're welcome, welcome to the forum, thanks for the feedback.