Excel Sheet
- WWS36
- Member
- Posts: 57
- Joined: Mon May 21, 2007 11:04 am
- Location: N. Ogden, UT
Excel Sheet
Can someone give me the Excel formula for separatin the house number from the street number/name and put them in 2 separate columns, please?https://tech.lds.org/forum/posting.php?mode=post&f=113#
- kd7mha
- Member
- Posts: 294
- Joined: Thu Mar 13, 2008 2:27 pm
- Location: Logan, Utah
Re: Excel Sheet
try these
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)
or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)
or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)
There are 11 types of people. Those who understand Gray Code and those that don't.