EMERGENCY - Please help with Excel Question - Very Very Urgent

[smbtnt]

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.

 

[jacinto]

sorry S, hope i could be of help.

j

 

[smbtnt]

thanks J, it is very urgent for work tomorrow.

 

[Atilla]

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

 

[shadowninja]

=concatenate(mid(a1,find(" ",a1,1)+1,20), " ", Left(a1,find(",",a1,1)-1))

 

[shadowninja]

gah. beaten.

 

[smbtnt]

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)

 

[smbtnt]

gah. beaten.

Thanks for your time Shadow!

Appreciated.

 

[Atilla]

gah. beaten.

Me Ninja' too... :cheesy:

 

[smbtnt]

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

 

[smbtnt]

sorry i meant John in cell1 and smith in cell2 from smith, john

last question

thanks

 

[shadowninja]

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!

 

[smbtnt]

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!

HEHEHE

me like ninja!
thanks buddy!

 

[shadowninja]

No probs.