Formula for format change?

[dbpowell89]

Hi,

I am running Excel 2007 in Windows XP.

How do I change a cell from "Smith,John" to "John Smith"?

Is there a formula I can use? What's the quickest way?


Thanks for the help!

 

[Weaver]

Assuming your string is in A2, you could use:

=MID(A2,SEARCH(",",A2)+1,255)&" "&LEFT(A2,SEARCH(",",A2)-1)

 

[dbpowell89]

Thank you, sir. That worked perfectly.

 

[T. Valko]

Hi,

I am running Excel 2007 in Windows XP.

How do I change a cell from "Smith,John" to "John Smith"?

Is there a formula I can use? What's the quickest way?


Thanks for the help!

Here's another one...

=MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))

 

[dbpowell89]

Thanks guys, appreciate the help.

 

[T. Valko]

Thanks guys, appreciate the help.

You're welcome!