add space in string (1 Viewer)

Gismo

Registered User.
Local time
Tomorrow, 01:18
Joined
Jun 12, 2017
Messages
1,298
Hi All

If i have a string for example 64-21-00,6-2 and i need to add a space after the comma, how would I go about doing so?
 

jdraw

Super Moderator
Staff member
Local time
Today, 19:18
Joined
Jan 23, 2006
Messages
15,364
with vba, something along this line
Code:
yourstring = "64-21-00,6-2"
newstring = replace(yourstring,",",", ")

Is this a 1 time thing and only for this string?
 

Users who are viewing this thread

Top Bottom