On Sat, Feb 7, 2015 at 4:59 PM, Kaj 70147pers...@telia.com wrote:
Assuming your string is in cell A1, cell B1 could contain:
=CONCATENATE(MID(A1,12,5), - ,MID(A1,34,5))
A wee more safe could be:
=CONCATENATE(MID(A1,12,5), - ,LEFT(RIGHT(A1,8),5))
In all fairness to Kaj, his
Composing the lines of an addressing area is easy to do with a query. Details
depend on the type of your database.
In Writer you can use a conditional field with a nested data source field
like this:
If condition: DataSource.QueryName.Title !=
Then:
--
View this message in context: