ExcelBanter - TEXT function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TEXT function (https://www.excelbanter.com/excel-discussion-misc-queries/374900-text-function.html)

gwc

TEXT function

The cells in column A contain between 1 and 43 characters. For
example:

Smith
Jones
Wolfeschlegelsteinhausenbergerdorffwhachama
A
Killkrew
Zacamulyxprotuli
Ngo
Frankenstein
Johannson

What is the syntax of the TEXT function so the result will have 43
characters?

All times are GMT +1. The time now is 12:43 AM.