» Add space between characters and numbers in Microsoft Excel
CATEGORY - Excel Editing , Excel Formula
VERSION - All Microsoft Excel Versions
data in cell A1: A100 Formula in cell B1: =LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-1) Result: A 100
Book Store:
Recommended Books:
- Microsoft Access 2002 for Dummies
- Finance and Accounting for Nonfinancial Managers
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Writing Excel Macros with VBA, 2nd Edition
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
