Trim text for series of cells

  • Thread starter Thread starter Pat
  • Start date Start date
P

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
 
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.
 
Back
Top