Trim text for series of cells

[Pat]

I want to use the TRIM function on a series of cells, possibly using a
macro. Each cell has a different text length. The one thing each cell
contains is a comma, this should be the trigger to tell the function where
to TRIM to.

Example :

Before
A1 = Aucuba japonica Rozannie, broad dark green leaves toothed above the
middle.

After
broad dark green leaves toothed above the middle.

Before
A2 = Aquilegia vul. pl. Nora Barlow, green foliage, red flowers.

After
green foliage, red flowers.


Anyone know the formula to perform this task?

regards
Pat

 

[lance]

How about
=TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)))

 

[JE McGimpsey]

If this is a one-off, a non-formula option may be easier. Choose
Data/Text to Columns. Select Delimited, then click Next. Check the comma
checkbox and click Finish.