How to add a space between the quarter and year, for example "Q12023" becomes "Q1 2023"

[cslagle005]

Hi all, beginner here and I'm striking out here trying to figure out the right RegEx formula to do this.  I have a bunch of columns that look like the below example and I want to add a space in between the Q# and YYYY. 

I've tried using the Formula tool with "REGEX_Replace([Name], '(\w\d)', '($1) " "') " but that isn't doing anything.  Any advice?

Example input:  

Q12023

Q22023

Q32023

Desired output:

Q1 2023

Q2 2023

Q3 2023

[binuacs]

@cslagle005 This can be achieved with the help of the Left() and Right() functions

[binuacs · Accepted solution]

@cslagle005 using the Regex_Replace function

[alexnajm]

@cslagle005 try this RegEx instead: REGEX_Replace([Name], "(\w\d)(\d{4})", "$1 $2")

[cslagle005]

Thanks all, I really appreciate all your replies!