View Single Post
  #1   Report Post  
amspalinger
 
Posts: n/a
Default How do I insert a symbol BEFORE text for multiple cells in Excel?

I'm trying to enter the same information into multiple cells that are already
filled - how can I do this in Excel??

Example -

12345
654321
78946
456798

I need to insert "3-" before each of the digits in these cells - There are
over 1000, that's why I don't want to do it manually. Any help would be
greatly appreciated!