LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clare
 
Posts: n/a
Default Prefix and Suffix

I want to be able to add a suffix and prefix to a column of data that has
been imported into an excel file without changing each cell individually.
Does anyone know of a function that will do this?

I just want to be able to put " infront of the data in the cell and " } at
the end. this is so that the data can then upload into an HP 48G+ calculator
that is running a program.

Help would be greatly appreciated as I am getting tired of changing 80 plus
cells!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding the same prefix or suffix to a range of cells Betty Turvy Excel Discussion (Misc queries) 5 July 12th 05 05:13 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"