ExcelBanter - How insert a dash in the third position of a column with data?

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

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

- - How insert a dash in the third position of a column with data? (https://www.excelbanter.com/excel-discussion-misc-queries/100205-how-insert-dash-third-position-column-data.html)

warren

How insert a dash in the third position of a column with data?

The column is imported data,,, already containing number values. Thank you.

tim m

How insert a dash in the third position of a column with data?

You could try this formula and see if it is what you want. (this assumes your
data starts in A1)

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

"warren" wrote:

The column is imported data,,, already containing number values. Thank you.

All times are GMT +1. The time now is 07:20 PM.