Forum Discussion
formula with a irregular field
Hi Fernando,
Sorry, I didn't catch what you try to do - split on different columns or what?
And better if you attach sample file with few records.
Thank you
- I am trying to split in columns but the data don’t follow a pattern like the 3 samples I place with the results
I know you tried Text to column feature in excel. However, in that feature, did you check the box next to "Treat consecutive delimiliers as one"?
If copy/paste the text from your post into the Excel the words in text are separated not only by spaces, but with combination of CHAR(160)&CHAR(32) as well.
However it's bit hard to understand is there some logic or that's series of copy/pasting effect.
Is there a formula that count the number of characters before the first empty field? So i can find a logic?
SergeiBaklan wrote:
If copy/paste the text from your post into the Excel the words in text are separated not only by spaces, but with combination of CHAR(160)&CHAR(32) as well.
However it's bit hard to understand is there some logic or that's series of copy/pasting effect.
AD660-A FBH1560-20 WBH R565-Z AD660 400 7695000 R565WBH
B1 = first word 7 characters
c1 = two empty space
d1 = 10 characters
e1 = two empty spaces
f1 = 3 characters
G1 = one space
h1 = 6 characters
etc
I1 = 45 empty field
