ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Search for lowercase followed by uppercase and insert paragraph (https://www.excelbanter.com/excel-discussion-misc-queries/249926-search-lowercase-followed-uppercase-insert-paragraph.html)

jgwors

Search for lowercase followed by uppercase and insert paragraph
 
Hi,
I have text in a spreadsheet imported from another application. Line breaks
have been removed so I have text like the following in cells
"lowercaseUppercase". Is there any way to find each occurrence of the
transition from lower to uppercase and insert a paragraph so the uppercase
text begins on a new line? This could be a vba macro is it can't be done
using standard commands.


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com