<div>
Try This:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim OLDString As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim NewString As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim commaPos As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim SirName As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim FirstName As String<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; OLDString = &quot;Criddle, Natalie&quot; 'Existing String<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; commaPos = InStr(4, OLDString, &quot;,&quot;, 1) 'Get Comma Position<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; SirName = Left(OLDString, Val(commaPos - 1)) 'Get Sirname<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; FirstName = Right(OLDString, Val(OLDString.Length - commaPos)) ' Get First Name<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; NewString = FirstName &amp;&nbsp;&quot; &quot;&nbsp;&amp; SirName<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox(NewString)
</div>


<div>
Hi thanks for the help - I am getting an erorr on this line - im not sure why<br />
<br />
&nbsp; FirstName = Right(OLDString, Val(OLDString.Length - commaPos)) ' Get First Name<br />
<br />
Object required ?
</div>


<div>
what version of vb are you using?
</div>


<div>
No probs, thanks for the grade.
</div>


<div>
<div class="content wysiwyg-content">
Hello  I have a string which always outputs <br />
<br />
Surname, firstname<br />
<br />
<br />
I would like to change the string to Firstname Surname using VBA. Changing around the firstname and surname and removing the ( , ) as well. <br />
<br />
Can someone help with this ?<br />
<br />
Thanks,<br />
<br />
GISVPN<br />

</div>
</div>


Hello  I have a string which always outputs 

Surname, firstname


I would like to change the string to Firstname Surname using VBA. Changing around the firstname and surname and removing the ( , ) as well. 

Can someone help with this ?

Thanks,

GISVPN


Try This:

        Dim OLDString As String
        Dim NewString As String
        Dim commaPos As String
        Dim SirName As String
        Dim FirstName As String

        OLDString = &quot;Criddle, Natalie&quot; &#39;Existing String

        commaPos = InStr(4, OLDString, &quot;,&quot;, 1) &#39;Get Comma Position

        SirName = Left(OLDString, Val(commaPos - 1)) &#39;Get Sirname

        FirstName = Right(OLDString, Val(OLDString.Length - commaPos)) &#39; Get First Name

        NewString = FirstName &amp; &quot; &quot; &amp; SirName

        MsgBox(NewString)

Hi thanks for the help - I am getting an erorr on this line - im not sure why

  FirstName = Right(OLDString, Val(OLDString.Length - commaPos)) &#39; Get First Name

Object required ?

Switch around characters within a string (VBA)

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.