Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 12-26-2018, 10:33 PM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default


But that's just what you have in the workbook I uploaded in cells K10:K12
Reply With Quote
  #17  
Old 12-27-2018, 12:48 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

Hi XOR

I am just using this way now.

If J10 or INPUT value is empty will return as empty instead of empty tag.

Is this possible?

thanks
ganesang
Reply With Quote
  #18  
Old 12-27-2018, 01:40 AM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Take a look here.
Attached Files
File Type: xlsx Category_2.xlsx (22.1 KB, 8 views)
Reply With Quote
  #19  
Old 12-27-2018, 01:57 AM
ArviLaanemets ArviLaanemets is offline Concatenate - function help Windows 8 Concatenate - function help Office 2016
Expert
 
Join Date: May 2017
Posts: 862
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

A possible solution.
Attached Files
File Type: xlsx Sample_data.xlsx (11.3 KB, 10 views)
Reply With Quote
  #20  
Old 12-27-2018, 02:01 AM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

@ArviLaanemets

Really, considering what OP wrote in #13.
Reply With Quote
  #21  
Old 12-27-2018, 02:14 AM
ArviLaanemets ArviLaanemets is offline Concatenate - function help Windows 8 Concatenate - function help Office 2016
Expert
 
Join Date: May 2017
Posts: 862
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by xor View Post
Really, considering what OP wrote in #13.
OK! I omitted this - was only browsing later posts!

It is even possible to do without hidden columns - using dynamic names instead. But having up to 100 dynamic names defined, I'm not sure what will happen with workbook speed!
Reply With Quote
  #22  
Old 12-27-2018, 03:26 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

Awesome Guys!!!

Almost i reached my goal

Thanks much!!!!
Reply With Quote
  #23  
Old 12-27-2018, 03:53 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

Hi XOR

One more help

if INPUT cell contain the function or formula its not considered as blank or empty cell and added empty tag also.


Please advise.
Reply With Quote
  #24  
Old 12-27-2018, 04:08 AM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Can't you explain better?
I'm not sure what you mean.
Reply With Quote
  #25  
Old 12-27-2018, 04:12 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

I have added the function to get INPUT value in cell J5 from another Sheet 1.

If there is no value in the Sheet 1 in particular cell, then returns J5 as empty.

So, in this case your function is put the empty code like <caget no = ""/>.

When trying to delete the function from J5 the empty tag is disappeared.

Is there any other way to retain the formula? in cell J5 without put empty code
Reply With Quote
  #26  
Old 12-27-2018, 04:14 AM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Please upload your workbook.
Reply With Quote
  #27  
Old 12-27-2018, 04:29 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

I need the yellow highlighted items in sheet 2 as empty without adding empty tags.
Attached Files
File Type: xlsx Book1.xlsx (15.4 KB, 9 views)
Reply With Quote
  #28  
Old 12-27-2018, 04:45 AM
xor xor is offline Concatenate - function help Windows 10 Concatenate - function help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,094
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

See the attached.
Attached Files
File Type: xlsx Category_3.xlsx (15.4 KB, 9 views)
Reply With Quote
  #29  
Old 12-27-2018, 05:17 AM
ArviLaanemets ArviLaanemets is offline Concatenate - function help Windows 8 Concatenate - function help Office 2016
Expert
 
Join Date: May 2017
Posts: 862
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Or this!

To add reference levels, you have to add names strng#, text# and txtl# with according level number, and add according components to concantenate in name strng.

With this approach, there will be no need for helper columns, but you have to check it out yourself with large number of levels and source rows.

Btw, I checked it out with formula "=IF(1=1,"","") in column A of Sheet1 - the name strng returns empty string when formula in source cell returns empty string.

Update! When adding/editing dynamic names strng#, text# and txtl#, you MUST have some cell (on any sheet) - with same row number as the one you put into name formula - to be active! Otherwise references will be wrong (to wrong row)!
Attached Files
File Type: xlsx Sample_data2.xlsx (11.7 KB, 9 views)
Reply With Quote
  #30  
Old 12-27-2018, 05:31 AM
ganesang ganesang is offline Concatenate - function help Windows XP Concatenate - function help Office 2016
Competent Performer
Concatenate - function help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

Thanks both of you!!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate - function help Concatenate function for displaying numbers in words officeboy09 Excel 13 08-09-2021 12:59 PM
Concatenate - function help Help need for concatenate function issue ganesang Excel 5 11-24-2018 12:27 AM
Concatenate - function help RIGHT Function With Concatenate (?) VBA-Need Help with Macro rsrasc Excel Programming 4 08-22-2018 12:17 PM
Concatenate - function help Concatenate b16 Excel 1 01-09-2017 04:51 PM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft