• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

seperate data in excel

Hi

I have a set of data coming in this format
09 FD 7E 00 02 00 00 02 12 11 C2 00 00 01 7D 00
how can i seperate them in individual columns in excel like the one i have attached?
seperate.xls
0
csharp_learner
Asked:
csharp_learner
  • 2
  • 2
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Data > Text to columns > Delimited > 
Select space as delimiter
Continue with dialog
0
 
csharp_learnerAuthor Commented:
can you show me on the attached example?
0
 
redmondbCommented:
Hi, csharp_learner.

Please see attached (using Mid() in formulas).

I assumed that you wanted leading and trailing blanks dropped, but this is easily changed, if necessary.

Regards,
Brian seperate-V2.xls
0
 
redmondbCommented:
Thanks, csharp_learner!
0
 
Saqib Husain, SyedEngineerCommented:
Oh I did not see your file.

In this case you need a fixed width option instead of a delimited option. See demo.

BTW while this file was uploading you had already accepted the solutions. You did not have to accept mine as it was not precisely what you wanted. This demo is good for either a one-time run or a separation which varies frequently. For a defined separation you should go ahead with Brian's solution.

Saqib
ssaqibh-514969.flv
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now