Split lines in excel by delimeter?
I wish to know if its possible to do the following: In case of the
following scenario:
a value1 3
b value2 1
c value3\nvalue3_1\nvalue3_2 1
d value4 1
e value5\nvalue5_1 1
to transform it into: a value1 3 b value2 1 c value3 1 c value3_1 1 c
value3_2 1 d value4 1 e value5 1 e value5_1 1
I dont mind that if the input is in sheet1, the output is in sheet2. my
excel skills are pretty much a beginner, so im not sure if thats even
possible
No comments:
Post a Comment