How to take part of the information from one cell and put in another cell

[jlfromm]

I am being in files and the facility and provider number out put are in the same cell: see below:

I need the 0151233 to go under the provider number instead of the facility 

how do I achieve this ?

[Felipe_Ribeir0 · Accepted solution]

Hi @jlfromm 

One way of doing this

[binuacs · Accepted solution]

@jlfromm One way of doing this

[jlfromm]

OK that worked for the Provider number, How to i get the facility name not to include the provider number 

[Taylor_S · Accepted solution]

You can change the expression within the RegEx tool to account for both the name and the number, then rename the newly parsed fields within the same tool, and use a Select tool to remove the initial field that was parsed, thereby leaving you with the desired output :)

[binuacs]

@jlfromm