Excel Sheet

2 postsstarted by WWS36 2016-04-12 09:21 UTC1,758 viewsoriginal topic

Member

#1
2016-04-12 09:21 UTC

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

#2
2016-04-12 12:07 UTC

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)

There are 11 types of people. Those who understand Gray Code and those that don't.