Problem:
I have a list of 1000+ names. Some are in conventional format eg: "Joe Bloggs" while others are inverted / comma delimited eg: "Bloggs, Joe".
Previously, I have got round this by converting text to columns (cell A to B & C) and then combining eg C1&" "&B1
Would it be possible to automate this using a macro that doesn't split the column? I was thinking something along the lines ...
For all cells in range
If cell.value contains ", " then
RHS & " " & LHS
End if
Next
Obviously the above is nonsence code but that is my line of thinking
I have a list of 1000+ names. Some are in conventional format eg: "Joe Bloggs" while others are inverted / comma delimited eg: "Bloggs, Joe".
Previously, I have got round this by converting text to columns (cell A to B & C) and then combining eg C1&" "&B1
Would it be possible to automate this using a macro that doesn't split the column? I was thinking something along the lines ...
For all cells in range
If cell.value contains ", " then
RHS & " " & LHS
End if
Next
Obviously the above is nonsence code but that is my line of thinking