Microsoft Office: Pasting bullet lists from Word to Excel

By J. Carlton Collins, CPA

Q. I'm trying to paste a bullet list from Word into a single cell in Excel, but when I do, my paste job spans multiple rows. Is there an easy way to paste a long bullet list into a single cell?

A. To paste a bullet list from Word into a single cell in Excel, copy the bullet list in Word, toggle to Excel, select the desired cell, press the F2 key to invoke edit mode, and then paste, as suggested by the screenshots below. The bullet list will paste into a single Excel cell.

techqa1

About the author

J. Carlton Collins, CPA, (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

Get your clients ready for tax season

Upon its enactment in March, the American Rescue Plan Act (ARPA) introduced many new tax changes, some of which retroactively affected 2020 returns. Making the right moves now can help you mitigate any surprises heading into 2022.

100th ANNIVERSARY

Black CPA Centennial, 1921–2021

With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.