separating text to column

[mjm2001]

i have a list of names in Excel and need to separate them into firstname, lastname, middle. However, the name is listed LastnameFirstnameMiddle

Ex:

SmithJohn
DoeFrankJames
BeckJoel
BlankJefferyE

Is there a way to search the cell on the next capitalized letter and separate it that way?

 

[fredericofonseca]

You can either create a user defined function to do it, or you can use VLOOKUP.

Either way you will have a problem with the parsing, as based on your example you don't always have all three "names", and on top of that I bet you can also get something like this.

McGuinnessShaneHenry

In this case you have 4 Upper case letters, but only three names, and you need to split them correctly.

Other situations can occur, and dealing with them is not easy.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com