Bring back lowercase values

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

Pat

Anyone got a solution to return only lowercase vaues in a string. Excluding
where an x is on its own.


Example1
Abelia x grandiflora Francis Mason
Returns
grandiflora

Example2
Abies balsamea f. hudsonia
Returns
balsamea f. hudsonia

Example3
Abutilon vitifolium var. Album
Returns
vitifolium var.

Example4
Abies nordmanniana Golden Spreader
Returns
nordmanniana


Much appreciate if you can help.

Pat
 
Hi Pat

Haven't see you round for a while.
You could use Data>Text to Columns>use Space as delimiter to break each
cell into separate words.

Then in a column to the right of the parsed data (i used column H) enter
=IF(A1="","",IF(A1="x","",IF(EXACT(LOWER(A1),A1),A1,"")))
Copy across as far as required

In the first available column after this (I used column O)
=TRIM(H1&" "&I1&" "&J1&" "&K1&" "&L1&" "&M1&" "&N1)
 
Hello Roger,

Good to hear form you, my focus has been directed elsewhere of late.

Your solution gave me the result i wanted, many thanks.

Pat
 
You must log in or register to reply here.
Back
Top