Mr_Wistles
Distinguished Member
Morning dudes and duddetes. I have an Excel problem that has got me stumped.
I have a list of cells which contain names (forename and surname) and a code number. I need to split this into three separate cells but I am unsure how to do it as the names are different lengths. Normally I would just use text to columns but the source data does not have a delimiter in it.
I have a list of cells which contain names (forename and surname) and a code number. I need to split this into three separate cells but I am unsure how to do it as the names are different lengths. Normally I would just use text to columns but the source data does not have a delimiter in it.