EMERGENCY - Please help with Excel Question - Very Very Urgent

smbtnt

Established member
Messages
710
Likes
21
I am struggling to concatenate: Smith, John into John Smith.
Using this formula
=CONCATENATE(MID(A1,FIND(" ",A1,1)+1,20), LEFT(A1,FIND(",",A1,1)-1))

I get johnsmith and not john smith

Can someone please help very urgently - Thanks.
 
I am struggling to concatenate: Smith, John into John Smith.
Using this formula
=CONCATENATE(MID(A1,FIND(" ",A1,1)+1,20), LEFT(A1,FIND(",",A1,1)-1))

I get johnsmith and not john smith

Can someone please help very urgently - Thanks.

Try this old boy...

=CONCATENATE(MID(A1,FIND(" ",A1,1)+1,20)," ", LEFT(A1,FIND(",",A1,1)-1))

Added another text entry and shifted 2nd line of text to third and left new second text line with blank " " etc...

Regards
 
gah. beaten.
weeping.gif
 
Awesome

Thanks Atilla, really really appreciated.

Mega helpful of you - hope I could return the favor.

ps: I am shorting cable and other GBP pairs on all pullbacks tomorrow (tight stops ofcourse);)
 
Help

Atilla, Shadowninja...

How would I return John. Smith from Smith, John

Sorry that should read John in cell1 and Smith in cell2 from Smith, John
 
Last edited:
sorry i meant John in cell1 and smith in cell2 from smith, john

last question

thanks
 
how about one cell: =LEFT(A1,FIND(",",A1,1)-1)
and other cell: =MID(A1,FIND(" ",A1,1)+1,20)

if you could do that concatenation formula the rest is easy!
 
Top