introduction excel training - inputting text excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024

Hide

Contact Us About Resources Sign in

Solutions Through Learning

Excellent

Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is empty

Solutions Through Learning

Callback

Sign in

Basket

Menu

Call us on 0207 987 3777 or Search our website

Courses
- Application Training
  - Excel
    - All Excel
    - Introduction
    - Intermediate
    - Advanced
    - Advanced - Formulas & Functions
    - Advanced - For Power Users
    - VBA
    - VBA Introduction
    - VBA Intermediate
    - VBA Advanced
    - Charting
    - Dashboards for Business Intelligence
    - Advanced Excel Dashboards
    - Forecasting & Data Analysis
    - Power Query
    - PivotTables
    - PowerPivot
    - Financial Modelling
    - Excel for Finance Professionals
  - Microsoft Office 365
    - 365 Adoption Program
    - 365 Explained
    - 365 Ambassadors
    - 365 End Users
    - OneNote
    - Teams
  - ChatGPT
  - Power Automate
  - Power BI
  - Powerpoint
  - Access
  - Word
  - MS Project
  - Sharepoint
  - Outlook
  - Visio
  - View all 200+ Courses
- Productivity Training Programs
- Professional Development
  - All Professional Development
  - Taking Minutes
  - Time Management
  - Organisational Skills
  - Negotiating Skills
  - Presentation Skills
  - Effective Communication Skills
  - Assertiveness At Work
  - View all 50+ Courses
- Management Training
  - All Management Training
  - Introduction to Management
  - Managing Teams Remotely
  - Mentoring
  - Managing Change
  - Leadership Development
  - View all 50+ courses
- Sales & Customer Service
  - All Sales & Customer Service
  - Customer Service Excellence
  - Excellent Account Management
  - Fundamentals of Selling
  - Selling Skills Programme
  - View all 20+ courses
- Financial Training
  - All Financial Training
  - Finance for Non Financial Managers
  - Effective Budgeting and Beyond
  - View all Courses
- Project Management
  - All Project Management
  - Project Management course
  - Microsoft Project
  - PRINCE 2 Foundation
  - PRINCE 2 Practitioner
  - View all 18+ courses
- eLearning Solutions
Promotions
- Promotions
- Excel Courses London
Schedule
- Public Schedule
- How to Book
- Reschedule
- Last Minute Deals
- What to Expect
- Venues and Equipment Hire
- Industry Leading Pricing model
Formats
- All Formats
- Public Scheduled Courses
- On-Site Training
- Productivity Training Programs
- Closed Company Events
- Online Classroom (Virtual)
- Consultancy
- One to One Training
- Training Needs Analysis
- Floor Walking
- Roll Out
- E Learning
- Executive Coaching
Our Clients
- Client List
- Online Reviews
- Client Testimonials
- Client Feedback
- Featured Case Studies
Contact Us
About us
Resources
Your account
Sign in

Home » Resources » Forum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Inputting text in Excel

introduction excel training - Inputting text in Excel

Resolved · Low Priority · Version Standard

Tue 19 Jun 2007, 14:08 Delegate Tom said...

Tom has attended:
Excel Intermediate course

Inputting text in Excel

When I am in MS Word, hitting the enter/return key means that the cursor drops down to the next line. How do I do this in Excel? I know there is a way to do this but I have forgotten! At the moment I have to press space bar until I get to the right edge of the box.

Tue 19 Jun 2007, 16:01 Trainer Richard said...

RE: Inputting text in Excel

Alt + enter

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5 2224 reviews