W
Wenom
I'd like to know if any of you could write a macro for me. This is rather
complicated and I'm not sure if it's possible to do something like that
with a macro.
I will give you an example and try to show what it should do.
The excel file i a set of cells which are in one column.
They look like that:
Q: such that is without people and sad (about aplace)
A: desolate ['desolet]
Q: sepsis (med)
A: infection/gangrene ['gengrin]
As you can see there are empty spaces between them plus they never start
from numbers.
The macro should do the following. I'll put comments in ' '
Q: such that is without people and sad (about aplace)
'the first line starts from Q: but it's longer than 1 word I try to swap,
after swap i see that there's a square bracket i delete the square
brackets and delete what's inside them. After swapping I join the cells
and replace Q: or A: depending on their order with :'
A: desolate ['desolet]
'the text should now look like that'
A: desolate : such that is without people and sad (about aplace)
Q: sepsis (med)
'I see the oval braket i delete it and what's inside. The first part is
one word only then so I don't swap.'
A: infection/gangrene ['gengrin]
'the text looks like that'
Q: sepsis : infection/gangrene
'If both the first and the second part are longer than 1 word ecen after
the deletion of square and oval brackets i skip and continue to the next
pair.
I'd be really greatful for your help.
complicated and I'm not sure if it's possible to do something like that
with a macro.
I will give you an example and try to show what it should do.
The excel file i a set of cells which are in one column.
They look like that:
Q: such that is without people and sad (about aplace)
A: desolate ['desolet]
Q: sepsis (med)
A: infection/gangrene ['gengrin]
As you can see there are empty spaces between them plus they never start
from numbers.
The macro should do the following. I'll put comments in ' '
Q: such that is without people and sad (about aplace)
'the first line starts from Q: but it's longer than 1 word I try to swap,
after swap i see that there's a square bracket i delete the square
brackets and delete what's inside them. After swapping I join the cells
and replace Q: or A: depending on their order with :'
A: desolate ['desolet]
'the text should now look like that'
A: desolate : such that is without people and sad (about aplace)
Q: sepsis (med)
'I see the oval braket i delete it and what's inside. The first part is
one word only then so I don't swap.'
A: infection/gangrene ['gengrin]
'the text looks like that'
Q: sepsis : infection/gangrene
'If both the first and the second part are longer than 1 word ecen after
the deletion of square and oval brackets i skip and continue to the next
pair.
I'd be really greatful for your help.