Excel Sheet

Discussions about the Ward Directory and Map tool on churchofjesuschrist.org.
Post Reply
User avatar
WWS36
Member
Posts: 57
Joined: Mon May 21, 2007 11:04 am
Location: N. Ogden, UT

Excel Sheet

#1

Post by WWS36 »

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
kd7mha
Member
Posts: 294
Joined: Thu Mar 13, 2008 2:27 pm
Location: Logan, Utah

Re: Excel Sheet

#2

Post by kd7mha »

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.
Post Reply

Return to “Ward Directory and Map”