high comma for each figure in every worksheet before and after the figure

[torti111]

Hi all,

I have an Excel file.

In this there are different worksheets. For each figure in column A I need a high comma before and after the figure.
For example: 680583 is in A15 and I need '680583'

Hope anybody has a good solution for this.

[than_gold]

Try this concatenate formula to add high coma to all cells by doing it next col B (should be blank one if not blank insert new one).

Please Login or Register  to view this content.