Splitting out text from numbers

[Ahasan13]

Hi All,

I am trying to split out numbers and text and I got it by using RegEx and under Regular expression, I put in "(\d+)\s(.+)" 

Screen shot of Original                                                                                 

Screen shot of after applying RegEx

My question is how do I get that "?" out? Thanks in advance for all the help!

[binuacs]

@Ahasan13 Can you try (\d+)\s\.(.*)

[Ahasan13]

Does not work 

[binuacs · Accepted solution]

@Ahasan13 I guess then it is not a period character, some non-ascii character. Can you try the below formula

(\d+)\s[^A-Za-z](.*)

[Christina_H · Accepted solution]

Maybe try (\d+)\s.\s(.+)

However if all your data is in the same format, you could also use text to columns or just formulas, e.g. Left([Account Name],4) and Right([Account Name], Length([Account Name]-7)

[Ahasan13]

This worked for me thank you! Also going to post another question regarding separating out things like this 

"Total Assets → Current Assets → Cash" 

Some of them have 2 arrows and some have more. I tried using the same formula but I guess it doesn't work for that. 

[Christina_H · Accepted solution]

I don't know how it would work with RegEx, but you can copy the arrow into a Text to Columns tool and it works just fine

[Ahasan13]

thank you this worked!

[binuacs]

@Ahasan13 Another option to replace the non-printable characters