Excel Graph Plotting

**callsaravananr** · 07-12-2009, 11:17 AM

I use spectrometer in my reesearch. The datas are in (a, b) format in single cell. Is it possible to seperate a and b seperately? like a in seperate cell and b in seperate cell?

Please help

**martindwilson** · 07-12-2009, 11:25 AM

probably! but what is the exact format?
but if they are seperated by ,
then you could just use data/text to columns to sepearate them or
in b1
=--left(a1,find(",",a1)-1) and in c1=--mid(a1,find(",",a1)+1,255)

**callsaravananr** · 07-12-2009, 11:31 AM

Thats great dude. Thank you very much. It worked. From where I can learn all these stuffs?

Great!!!!

Saravanan

**martindwilson** · 07-12-2009, 11:36 AM

excel help perhaps!!!!

**arthurbr** · 07-12-2009, 12:28 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save