You are reading a single comment by @moocher and its replies.
Click here to read the full conversation.
moocher-
I've probably overengineered it
You've not started to over-engineer it until your formula, at the very least, includes multiple nested if statements to validate the data and datatype in cell A1.
Real over-engineering would include purposefully circular references that fed back with auto-generated suggestions to correct the error.
NotThamesWater
You don;t need valuetotext() here - this will convert it to a string already
=""&A1&"+C1 "