Do the two columns you concatenated still exist? If so, just use a formula
that references them directly. If not, where do you have the concatenated
text at? I ask because you are saying you want the results in Columns A and
B... if your concatenated text is in Column A, then you will need to use a
macro to do what you want.

--
Rick (MVP - Excel)


"Nikki" wrote in message
...
I have concatenated two fields but now need to separate the name from the
branch number in the example below

1001John Doe

I need 1001 in one column and John Doe in the other.

Column A Column B
1001 John Doe