NT
Size: a a a
2019 June 11
AS
hello, thanks for let me join this group.
AS
i'm trying to split and join it again...
how to join it again and the result is tobe :
how to join it again and the result is tobe :
(A)-123.(B)-94.(C)-1010.(D)-465
Ю
i'm trying to split and join it again...
how to join it again and the result is tobe :
how to join it again and the result is tobe :
(A)-123.(B)-94.(C)-1010.(D)-465
Do you really need split and join? How about REGEXREPLACE?
Ю
=REGEXREPLACE(A1,"(\D+)(-\d+\.?)","($1)$2")АИ
=REGEXREPLACE(A1,"(\D+)(-\d+\.?)","($1)$2")👍
AS
OK thank you, i'll try it. actualy the text is more complex.
АИ
That regex divides text to numbers and letters than format them.
AS
=REGEXREPLACE(A1,"(\D+)(-\d+\.?)","($1)$2")how to replace 2 space on text?
already try :
already try :
" " and " "&" "АИ
trim() function replaces 2 spaces or more with 1 space
AS
ok. i'll try thanks
Ю
trim() function replaces 2 spaces or more with 1 space
👍
AS
👍
your formula for separate between text and number, but when the number inserting text the result to be like that..,
already try but still not find it..
already try but still not find it..
Ю
=trim(REGEXREPLACE(A1,"(\D+)(-\d*\D*\.?)","($1)$2"))
Try this one. Not sure, but maybe it will work.Ю
your formula for separate between text and number, but when the number inserting text the result to be like that..,
already try but still not find it..
already try but still not find it..
=REGEXREPLACE(A2,"(\D*)(-\d*\.*)(\D*)(-\d*\.*)","($1)$2($3)$4")
Ю
И пусть меня покарают боги за это...но потом =)
AS
=REGEXREPLACE(A2,"(\D*)(-\d*\.*)(\D*)(-\d*\.*)","($1)$2($3)$4")
sorry not work :(
RY
Привет. Только у меня не работает нормально Vlookup? Когда пытаешься искать по нескольким колонкам, то просто N/A.
v
Привет. Только у меня не работает нормально Vlookup? Когда пытаешься искать по нескольким колонкам, то просто N/A.
кури мануал
RY
курил, но уже наверное глаз замылился, не вижу в чем косяк