Hi All,
If I have information like these all in one cell, is there anything to split them up so that they will be in different cell?
Ex:
03:00 9730.8 457.6 8378.0 .3657 -> cell A1=03:00 B1=9730.8 C1=457.6 D1=8378.0 E1=.3657
Thanks,
VBisgreat
Hi All,
If I have information like these all in one cell, is there anything to split them up so that they will be in different cell?
Ex:
03:00 9730.8 457.6 8378.0 .3657 -> cell A1=03:00 B1=9730.8 C1=457.6 D1=8378.0 E1=.3657
Thanks,
VBisgreat
Sure:
click the Data tab and select text to columns.
choose space as your delimiter.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks