Cursor Control in Excel:

When I press an arrow key, the cursor doesn't move, but the whole spreadsheet moves down, up, right, left--depending on the key. What's up?

Answer: Have a look at your Scroll Lock. If it's on, it might be causing the problem.

> hight the column
> Data
> Text to Columns
> Delimited
> Next
> Comma
> Next
> Finish

[url] https://support.office.com/en-us/article/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23 [/url]
[url] https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7 [/url]
[url] https://www.cedarville.edu/insights/blog/excel-how-to-parse-data-split-column-into-multiple.aspx [/url]

=A2&B2

[url] https://trumpexcel.com/combine-cells-in-excel/ [/url]

How to remove entries in bold?

Sub CheckForBold()

Dim wks As Worksheet
Dim iRow As Integer

iRow = 1
Set wks = Application.ActiveSheet

Do Until wks.Cells(iRow, 4).Value = ""
If wks.Cells(iRow, 4).Font.Bold = True Then
wks.Rows(iRow).Delete
Else
iRow = iRow + 1
End If
Loop

End Sub

[url] http://www.excelforum.com/excel-programming/478043-delete-rows-with-bold-or-italic-text.html [/url]

flash fill > remove duplicate

> Select column(s)
> Home
> Format
> AutoFit Column Width

[url] https://smallbusiness.chron.com/add-cells-across-multiple-spreadsheets-44275.html [/url]