Thread: How do I add dashes to a string?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
57chevy 57chevy is offline
external usenet poster
  
Posts: 1
Default How do I add dashes to a string?
I have a column of thext in Excel that is

111222333
or
111222333L

And want to convert it so that it reads

111-222-333
or
111-222-333L

I have applied "=TEXT(A1, "000-000-000")" and have the format
"111-222-333" but when the original string has an "L" on the end, it's not
included. How can I reformat and preserve the L when it is in the original
string?

Reply With QuoteReply With Quote