Thread: [Solved] Replace space with paragraph mark
View Single Post
 
Old 08-21-2018, 09:18 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
And change:
.Text = " A2"
to:
.Text = "^wA2"

if you wanted to include any type of white space in front of A2
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote