I am trying to write either a formula or Macro to find the last space in a string before the 38th character. My problem is that my data is not standard and I don't want to truncate in the middle of a word that falls at 37 characters. See example below.
<tbody>
</tbody>
Free-bird Real Opportunities And Encyclopedias LLP = 50 Char
<tbody> </tbody> |
<tbody>
</tbody>