» Add space between characters and numbers in Microsoft Excel
CATEGORY: Excel Editing , Excel Formula |
VERSIONS: All Microsoft Excel Versions |
data in cell A1: A100 Formula in cell B1: =LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-1) Result: A 100 |
| Screenshot // Add space between characters and numbers in Microsoft Excel |
![]() |
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Business Plans For Dummies®
- PowerPoint® 2002 For Dummies®
- Windows XP All-in-One Desk Reference For Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.






