# find first number in a cell and move that number and all following text to the next column

1. ## find first number in a cell and move that number and all following text to the next column

I posted this a few days ago, but I couldn't reply to the thread, so I'm trying this again.

I need to find the first number in a cell and move all the text following that number (including that number) to the next column over.

For example:

This text would be in the cell:
Acme Logging Company 22288 Redwood Street Acmeville, FL

I need to move 22288 Redwood Street Acmeville, FL to the next column over

TIA  Register To Reply

2. ## Re: find first number in a cell and move that number and all following text to the next co

=MID(A1,MATCH(1,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1)*1,0),LEN(A1)+1-MATCH(1,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1)*1,0)) ---- CSE

Resut is : 22288 Redwood Street Acmeville, FL  Register To Reply

3. ## Re: find first number in a cell and move that number and all following text to the next co

a variation on this...
=RIGHT(A10,LEN(A10)-SEARCH(LOOKUP(99^99,--("0"&MID(A10,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10&"0123456789")),ROW(1:10000)))),A10,1))  Register To Reply

4. ## Re: find first number in a cell and move that number and all following text to the next co

formula array CSE
=MID(A1;MIN(IF(ISNUMBER(--MID(A1;ROW(1:100);1));ROW(1:100)));LEN(A1))  Register To Reply

5. ## Re: find first number in a cell and move that number and all following text to the next co

=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),255) should do  Register To Reply

6. ## Re: find first number in a cell and move that number and all following text to the next co

Thanks for the help. Just what I was looking for. You guys rock!  Register To Reply