Microsoft Office Forums - View Single Post - [Solved] How to use mid or left functions to seperate city,st,zip with no commas

Thread: [Solved] How to use mid or left functions to seperate city,st,zip with no commas

View Single Post

Old

11-10-2014, 10:28 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

Here is your attachment with the formulas filled in. Some of your addresses have an extended zip code. Just filter these and run the formula in red font for these addresses.

Attached Files

example for forum 1.xlsx (14.0 KB, 11 views)

Reply With Quote