Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-05-2022, 10:24 AM
Shmuel G Shmuel G is offline How do I convert a line of text to title case? Windows 10 How do I convert a line of text to title case? Office 2019
Novice
 
Join Date: Jul 2022
Posts: 3
Shmuel G is on a distinguished road
Default

Quote:
Originally Posted by Shmuel G View Post
This technique destroys any character formatting within the selection, such as change of fonts. Is there a simple way to replace the text of the range with the new version, while preserving the original formatting?
It seems that replacing the .Text of each of the Characters in a range, one at a time, will preserve the formatting, but that requires the replacement string to be the same length as the original string.

If not for the trimming and replacement of double spaces, formatting could be preserved by replacing


Code:
.Text = StrTmp
with
Code:
  Dim i As Long
  For i = 1 To .Characters.Count
    .Characters(i).Text = Mid$(StrTmp, i, 1)
  Next
Reply With Quote
  #17  
Old 07-06-2022, 07:19 AM
macropod's Avatar
macropod macropod is offline How do I convert a line of text to title case? Windows 10 How do I convert a line of text to title case? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,617
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you at least try the code in post #3?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #18  
Old 07-06-2022, 07:40 AM
Shmuel G Shmuel G is offline How do I convert a line of text to title case? Windows 10 How do I convert a line of text to title case? Office 2019
Novice
 
Join Date: Jul 2022
Posts: 3
Shmuel G is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Did you at least try the code in post #3?
Yes, I entered in all the code in post #3 and ran the second snippet on a selection in which some words were in a different font. Character formatting was lost.
Reply With Quote
Reply

Tags
text conversion, title case

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a new TITLE property from text already within document smndnm Word VBA 6 07-04-2014 08:27 PM
Stop review query when small case at beginning of line dsrose Word 2 01-22-2014 12:19 AM
How do I convert a line of text to title case? True Title Case for First Row of All Tables Marrick13 Word VBA 14 12-11-2013 09:12 PM
How do I convert a line of text to title case? Custom Text Filter for this particular case tinfanide Excel 2 09-13-2011 05:08 AM
How do I convert a line of text to title case? From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft