Logo of Microsoft Excel Graphic showing arrow on right direction Logo of Microsoft Word

So there I was on Friday, helping the fine folks at the Arc of Bakersfield in California importing the people they support into Therap when I came across a problem that I didn’t have an answer for. They had their names stored in one cell e.g. “Smith, John”. unfortunately our importing tool wants them to be in two separate fields. I could not for the life of me work out how to do it, so I called Warren.

“Oh it’s easy” says he, “just paste it into Word and replace the comma with hat T”.

“OK” says I, “One more time…”

Actually it was pretty easy, here’s how it goes.

  1. Copy the cells you want to split
  2. Do a “Paste Special” into Word with no formatting (if you’re not sure what Paste Special is , look here)
  3. Then do a search and replace, replacing “, ” with “^t”
  4. Now go back to your Excel spreadsheet and insert two colums
  5. Copy the Text from Word
  6. Paste into Excel
  7. Voila!

I was impressed!

Hope it makes some sense

:: Justin ::