I have a column (B)with names and need to create a new column (C) that includes this name along with a prefix. Not too difficult...
= "text prefix" & cell ref
But...in some instances there is superfluous info in the original name, that I do not need to include. Any ideas how to this? The extra info is at the start of original data in some Coloumn B cells.
= "text prefix" & cell ref
But...in some instances there is superfluous info in the original name, that I do not need to include. Any ideas how to this? The extra info is at the start of original data in some Coloumn B cells.