View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Insert a keyboard Character e.g (/)in multiple cells of a workshee

I want to change my data, in excel, from the form, e.g (100) to (100/100)
for another software to recognize the data. The data is huge and wish I could
do it automatically .
I have tried the 'Concatenate' formula but it returns the product of the
formula instead of the form I want it. Any help please?

=concatenate A1,/A1 meant to change (100) to (100/100) returns (1)