How to Enter a Line Break Character in the Formula Bar

mstuf

Active Member
Joined
Feb 4, 2003
Messages
321
Office Version
  1. 2016
Platform
  1. Windows
Good Evening --

In one of my Spreadsheets, I have a column of text cells that contain product Descriptions.
Most of those Cells are filled by copying from a web page and and pasting the title info shown on the webpage into the formula bar. I paste it into the formula bar to avoid the HTML Color and size formatting and to avoid paste Special ( a hassle in Excel 2002 )

Often the Text that shows in the Formula bar will appear like this

Sony P6-MP30 Video 8 Standard Grade Metal Particle Video Cassette
by Sony


or sometimes


Ewoks - The Battle for Endor (1985)

Starring: Wilford Brimley, Warwick Davis VHS


BUT Sometimes I need to key in text descriptions manually. When I do they all appear in the formula bar as --

Sony P6-MP30 Video 8 Standard Grade Metal Particle Video Cassette by Sony

or


Ewoks - The Battle for Endor (1985) Starring: Wilford Brimley, Warwick Davis VHS

My text is all in one long line.

When I tab or Enter in the spot I would like to move to a new line, it just moves to the next cell --
There must be a character that does not show up that puts in a line break -
What is it and Can I enter it manually ?

Any Help Appreciated.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Thanks Again - I tried Control and Enter but didnt try Alt

Thank You Again -
 
Upvote 0

Forum statistics

Threads
1,215,309
Messages
6,124,180
Members
449,146
Latest member
el_gazar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top