Thread: How insert a dash in the third position of a column with data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
  
Posts: 430
Default 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.
Reply With QuoteReply With Quote