Excel Sheet

Discussions about the Maps Tool on lds.org.
User avatar
Posts: 57
Joined: Mon May 21, 2007 10:04 am
Location: N. Ogden, UT

Excel Sheet

Postby WWS36 » Tue Apr 12, 2016 2:21 am

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#

User avatar
Posts: 230
Joined: Thu Mar 13, 2008 1:27 pm
Location: Logan, Utah

Re: Excel Sheet

Postby kd7mha » Tue Apr 12, 2016 5:07 am

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.

Return to “Maps”

Who is online

Users browsing this forum: No registered users and 1 guest