Show partial cell content and make the rest invisible

[Lux Aeterna]

I'd like cell B1 to show only the first letter of its content, and make the rest of it invisible. I could use the LEFT function or hide content by using ****, but that's not what I need. I'd rather not use macros, as my file is already loaded.

 

[RoryA]

Is it static content or a formula?

 

[Candyman8019]

This can be achieved by changing the font color to white on all but the first letter...although likely easier done with VBA.

 

[Lux Aeterna]

It's actually several cells in B column. There's a macro that pastes data to those cells according to some criteria.

Their content differs in length, but it's always one word. So, I'm not sure how I could use the colour solution.

 

[RoryA]

You could add something to your code - for example:

Sub HideAllButFirst()
   Dim targetRange As Range
   Set targetRange = Range("B2:B17") ' change as needed
   
   Dim cell As Range
   For Each cell In targetRange.Cells
      If Len(cell.Value) > 1 Then
         cell.Characters(2).Font.Color = vbWhite
      End If
   Next cell
End Sub