Function for a contiues text string

J

jdimino

Hello,
Could someone tell me what function to use to convert cell A1 to
continues text string, just as I have cell B.
Could you please write the function for me and insert it in cell C1
See attached file

Thank you so much



From:

Edge Yellow (11-B), Body Pale Pearly Pink (56-B) With Shiny
White Veins, Small Eye Red (53-B), Stigmas Orange Red (33-A), Reverse
Yellow (11-B).

To:

Edge Yellow (11-B), Body Pale Pearly Pink (56-B) With Shiny Whit
Veins, Small Eye Red (53 B), Stigmas Orange Red (33-A), Reverse Yello
(11-B)
 
P

Pete

The only difference I can see is that 53-B has become 53 B after Small
Eye Red. If this is the case then you can use the SUBSTITUTE( )
function, entered in cell C1 as follows:

=SUBSTITUTE(A1,"53-B","53 B")

Pete
 
Top