Hi my friends
not find formula for concatenate cell that contain number and text > 0
xlsx in attachament
thanks...
Hi my friends
not find formula for concatenate cell that contain number and text > 0
xlsx in attachament
thanks...
Hi there,
It's a bit long-winded, but the following formula seems to do what you want:
The formula assumes that if the last two characters in a cell are " 0" then the contents of that cell should be ignored.Please Login or Register to view this content.
Hope this helps,
Regards,
Greg M
try this one
=MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CONCATENATE(A5,",",B5,",",C5,",",D5,",",E5,",",F5,",",G5,",",H5,",",I5,",",J5),"text 0",""),",",),"text",",text"),2,1000)
It quite tough make these type thing with formula's BTW yes you can do it with multiple if conditions as post #2 shows but you can do this with fully dynamic with formulas.
K5Formula:Please Login or Register to view this content.
Copy above formula towards column T
U5Formula:Please Login or Register to view this content.
Excel 2016 (Windows) 64 bit
A B C D E F G H I J K L M N O P Q R S T U 4Result 5text 2 text 10 text 0 text 0 text 0 text 0 text 0 text 0 text 0 text 33 text 2 text 10 text 33 text 2, text 10, text 33 6 Hope this would help you !!!
Sheet: Sheet1
Note yellow header show helper columns
Last edited by shukla.ankur281190; 02-11-2019 at 08:11 AM. Reason: Note pasted
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
work Ghozi...
thanksss...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks