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
|