View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

How about:

=REPLACE(A1,SEARCH(" ",A1,1)+2,2,", ")

It looks for the first space character, comes over two more, and replaces the
space with a space-comma.



Hayley wrote:

Sorry it should read
I have Woods T 3/1
i want Woods T, 3/1

Thank you

"Hayley" wrote:

I would like to insert a , with a cell.

i have Wood T 3,1

i would like to have
Wood T,3/1


--

Dave Peterson