View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Larry C[_2_] Larry C[_2_] is offline
external usenet poster
 
Posts: 4
Default Question about parsing a column of cells with a comma in text

Hello,

I have a column of cells that some of the cells have data like the following

124 Main Street, Suite 250

In a perfect world I would like to take the information after the comma and
move it to a cell next to it.

Then delete the comma.

Just posting on a remote chance that someone has done this before.

Thanks

Larry C