Thread: inserting special character in a cell as a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
johnnyboy johnnyboy is offline
external usenet poster
  
Posts: 1
Default inserting special character in a cell as a macro
I'm trying to copy 5600 items and I need to use a macro to save some time.
I have a column with numbers represented as text.
For example 01234 as text. the cell adjacent to it is a city ie. Los Angeles
I'm trying to use a macro so the first cell is #01234 - Los Angeles.
Can someone help me to figure out this macro.

Reply With QuoteReply With Quote