How to Extract text prior to line break?


Just add the below formale in the text and move the A1 to the cell you need to. Done. Lets keep this blog as simple a this.

=LEFT(A1,FIND(CHAR(10),A1)-1)

Bingo!


Few other tips and tricks of Excel are found below:


Formatting I
ctrl+1
Format cells dialog box
ctrl+5
Strikethrough
ctrl+B
Bold
ctrl+I
Italic
ctrl+U
Underline
Formatting II
shift+ctrl+`
General format
shift+ctrl+1
Format cell to two decimal places
shift+ctrl+2
Format cell to time
shift+ctrl+3
Format cell to date
shift+ctrl+4
Format cell to currency
shift+ctrl+5
Format cell to percentage
shift+ctrl+6
Format cell to scientific notation
shift+ctrl+7
Draws outline around your selection
Cell Selection
ctrl+A
Select All Cells in range
shift+F8
Add to selection
ctrl+[SPACE]
Select the current column
shift+[SPACE]
Select the current row
shift+HOME
Select to beginning of row
shift+END↵
Select to last used cell in row
shift+ctrl+HOME
Select to beginning of worksheet
shift+ctrl+END
Select to end of worksheet
shift+ctrl+8
Select data region surrounding active cell
shift+ctrl+O
Select all cell containing a comment
ctrl+[
Select cells that formula directly references
ctrl+]
Select formula that references the active cell
Data I
shift+ctrl+;
Insert Current Time
ctrl+;
Insert Current Date
ctrl+C
Copy
ctrl+V
Paste
ctrl+X
Cut
ctrl+Y
Repeat
ctrl+Z
Undo
shift+F2
Edit cell comment
ctrl+BACKSPACE
Display the active cell
Data II
alt+IC
Insert column
alt+IR
Insert row
ctrl+D
Fill Down
ctrl+R
Fill Right
shift+ctrl+=
Insert Cells, Rows, Columns
shift+ctrl+F3
Create name by using names of row and column labels
F2
Edit
Workbooks
ctrl+0
Hide columns
ctrl+9
Hide rows
ctrl+F10
Maximize or restore window
ctrl+F9
Minimize workbook
shift+ctrl+9
Unhide rows
F7
Spell check
Formulas
alt+=
AutoSum
ctrl+'
Copy formula from cell above
alt+ctrl+F9
Forces full calculation of all worksheets
shift+alt+ctrl+F9
Forces calculation with dependency tree rebuild
shift+ctrl+A
Insert argument names into formula
F3
Paste Name
shift+F3
Paste function into formula
shift+ctrl+'
Copy value from cell above
=
Begin a formula
ctrl+`
Toggle display of formula vs cell values
General
alt+F1
Insert a Chart sheet
alt+F11
Open Visual Basic Editor
alt+F8
Macro dialog box
shift+alt+F2
Save Workbook
ctrl+F11
Inset 4.0 Macro sheet
F1
Help
F4
Repeat last action
shift+F10
Display shortcut menu
Navigation
ctrl+END
Move to last used cell in a worksheet
ctrl+G
Goto
ctrl+HOME
Move to the first non-header cell of the sheet
F6
Next Pane
shift+↵
Go to previous cell
shift+F6
Previous Pane
HOME
Move to beginning of row
↵
Move down a cell in selected range
shift+↵
Move up a cell in selected range
ctrl+.
Move from corner cell to corner cell in range
↵
Go to next cell
Misc I
F10
Activate menu
alt+DOWN
Display AutoComplete list
ctrl+6
Show/Hide objects
ctrl+7
Show/Hide Standard toolbar
ctrl+8
Toggle Outline symbols
ctrl+↵
Fill the selected cell range with the current entry.
ctrl+F
Find
ctrl+F12
File Open
Misc II
ctrl+H
Replace
ctrl+O
Open
F8
Extend mode
F9
Recalculate all workbooks
shift+ctrl+F
Font Drop Down List
shift+ctrl+FF
Fill tab of Format Cell Dialog box
shift+ctrl+P
Point size Drop Down List
shift+F4
Find Next
shift+F9
Re-calculate active worksheet
TAB
Next tool