
Patrick Jones
Active Member
Members
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook

Forum Posts: 4
Member Since:
August 7, 2022
August 7, 2022


Jessica Stewart
Northern USA
Member
Members

Trusted Members

Trusted Members

Forum Posts: 202
Member Since:
February 13, 2021
February 13, 2021


Patrick Jones
Active Member
Members
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook

Forum Posts: 4
Member Since:
August 7, 2022
August 7, 2022


Patrick Jones
Active Member
Members
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook
Dashboards
Power Query
Power Pivot
Advanced Excel Formulas
Excel Tables
Excel
Word
Outlook

Forum Posts: 4
Member Since:
August 7, 2022
August 7, 2022


Philip Treacy
Admin

Forum Posts: 1518
Member Since:
October 5, 2010
October 5, 2010

Hi Patrick,
You can get the first part of the address with this
=IF(IFERROR(SEARCH(" Ste ",C2),0)>0,LEFT(C2,LEN(C2)-(LEN(C2)-SEARCH(" Ste ",C2))-1),C2)
and the second part of the address with this
=IF(IFERROR(SEARCH(" Ste ",C2),0)>0,MID(C2,SEARCH(" Ste ",C2)+1,LEN(C2)-SEARCH(" Ste ",C2)),"")
Please see attached file.
Regards
Phil
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Nada Perovic, Denise Lloyd
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27276
Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
