Move text to another cell after first comma only

[rogueakula]

I have seen numerous posts on how to separate text based on a common delimitator. However, my text contains multiple commas. I am looking to separate text after the first comma only. For example:

part/one/of/my/text, This is the second part, but it may contain one or more commas

I am looking to get it splint into two columns.

Column One	Column Two
part/one/of/my/text	This is the second part, but it may contain one or more commas

I thought that I could use Text to Columns but that moves based on all the commas in a cell. Any help would be greatly appreciated! Thank you in advance!

-Josh

 

[rogueakula]

I figured it out. I used:

=MID(A1, FIND(",", A1)+1,256)

After that I performed a find and replace using a wildcard after the comma (,*) and replaced the text with a blank.

I am sure that there are other methods but this works for what I need.