A Andy Teal New member Local time Today, 05:06 Joined May 11, 2023 Messages 28 May 11, 2023 #1 Hello Last edited: May 21, 2023
Gasman Enthusiastic Amateur Local time Today, 00:06 Joined Sep 21, 2011 Messages 17,079 May 11, 2023 #2 What have you tried as custom format?
C CJ_London Super Moderator Staff member Local time Today, 00:06 Joined Feb 19, 2013 Messages 17,563 May 11, 2023 #3 Use the replace function? Code: replace(“my text”, “ “, “ “)
A Andy Teal New member Local time Today, 05:06 Joined May 11, 2023 Messages 28 May 14, 2023 #4 Gasman said: What have you tried as custom format? Click to expand... No. but it seems an easy approach. Can you explain more?
Gasman said: What have you tried as custom format? Click to expand... No. but it seems an easy approach. Can you explain more?
Gasman Enthusiastic Amateur Local time Today, 00:06 Joined Sep 21, 2011 Messages 17,079 May 14, 2023 #5 Andy Teal said: No. but it seems an easy approach. Can you explain more? Click to expand... Just set a custom format in format cell, but it only appears to work for numbers. by
Andy Teal said: No. but it seems an easy approach. Can you explain more? Click to expand... Just set a custom format in format cell, but it only appears to work for numbers. by