Tech Forum

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#

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)