Thread: I need to add a dash five characters from the first in a cell
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
krasher krasher is offline
external usenet poster
  
Posts: 2
Default I need to add a dash five characters from the first in a cell
Thanks. This is exactly what I needed to do. The instructions were easy and
my envelopes mail merge correctly now.
Vivian

"Angela" wrote:

I have zip codes in a field fields that I need to add a dash between the
first part of the zip and the second four numbers so the instead of looking
like "902101234", it looks like "90210-1234". How do I do this?
Reply With QuoteReply With Quote