The split text to coloumns is returning 2 rows for each cell and not 2 coloumns. How do I get it to function?
it seems there are linebreaks in the Cells.
→→Search and replace:
search: \n
replace: \t
[x] regular Expression
→→ replace all
and try again →→Text to Columns … [x]Tabulator
1 Like
It did not function.
The search /n did not find any instances.
There is 2 instances in the cell and they are seperated with an “entry”
Here is the cell I am trying to transform
“90-51-11000-V3
Crossmember profile”
works for me with copy&paste this text into cell and the instructions above!!
there is a slash/ but not a backslash\
Yes, sorry. I read as the devel read the bible.
But still with \n I do not find the instance.
I will work on it but
thank you so much for your patience.
It was my first question here.