Removing data from a series

F

frobie

Hello everyone,
Thanks for the help on my last question, it got the job done!

I now need to remove data from a series. I have created a series o
numbers in a column based on messages in another column, heres a
example:

C1 C2 C3
1- LOAlarm 1-LOAlarm
2- LOLOAlarm 2-LOLOAlarm
3- LOLOLOAlarm 3-LOLOLOAlarm

This goes on for about 2000 messages and was created by the equation C
= C1&" " &C2 and now I have to reverse the operation to display onl
LOAlarm and such. Any ideas, or do I have to manually prune it out?

Thanks for any help and it is always a pleasure
 
F

Frank Kabel

Hi
are they all divided by a space? (your formula indicates that but your
example doesn't). If yes try:
=MID(B1,FIND(" ",B1)+1,255)
 
D

Dave Peterson

If the data is like your example, maybe you can just take Column 3 and do
data|text to columns--choose delimited and choose - (hyphen) as the delimiter.

Then add the dash back with a formula like:

=d1&"-"

Or if your data is always separated by the hyphen:

use a column of formulas like:
=LEFT(A1,SEARCH("-",A1))
and like:
=MID(A1,SEARCH("-",A1)+1,LEN(A1))
 
Top