LinkBack URL
About LinkBacks
With your data in A1:A?? put this in B1:
=IF(MID(A2,2,1)=".",A1&" "&A2,IF(EXACT(PROPER(LEFT(A2,2)),LEFT(A2,2)),"",A1&" "&A2))
and copy over and down. This will concatenate each successive string until it runs into the next question.
With your data in A1:A?? put this in B1:
=IF(MID(A2,2,1)=".",A1&" "&A2,IF(EXACT(PROPER(LEFT(A2,2)),LEFT(A2,2)),"",A1&" "&A2))
and copy over and down. This will concatenate each successive string until it runs into the next question.
Last edited by daffodil11; 11-07-2013 at 01:57 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks