Split Cells

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Oaktree

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
No. But, you can merge other cells to give the appearance.

(e.g. if A1:B1 are merged, A2:B2 look split as compared to the merged cell)
 
You must log in or register to reply here.

Similar threads

B
  • Question
Custom Split
Replies
4
Views
299
Joe4
Joe4
G
  • Question
Re-split csv value
Replies
0
Views
82
gleamng
G
M
  • Question
Split function to search for value in worksheet
Replies
3
Views
150
Fluff
Fluff
D
  • Solved
Error when splitting data by column
Replies
7
Views
71
D-Angle
D
A
  • Question
Splitting a master data set into a different workbook
2 3
Replies
20
Views
338
anon1999
A

Watch MrExcel Video

Learn Excel - Text Instead of Numbers in Pivot Table - Podcast 2223

Forum statistics

Threads
1,118,025
Messages
5,569,727
Members
412,289
Latest member
Kingchaos64

Share this page

Top