Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2171047%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171047%22%20slang%3D%22en-US%22%3E%3CP%3EI%20started%20a%20list%20of%20names%20but%20I%20need%20to%20put%20space%20between%20the%20title%20and%20the%20names%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2171047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I started a list of names but I need to put space between the title and the names

 

2 Replies

@debcool2002 

Could you please illustrate this by the sample?

@debcool2002 

 

Here is an example, you just need to customize it in your text

 

=LEFT(A1,5)&" "&RIGHT(A1,LEN(A1)-5)

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.