LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!

 
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
I need a symbol but "symbol" in the Insert menu is grayed-out. Nothappy Excel Discussion (Misc queries) 2 May 3rd 05 12:16 AM
Excel should have the same Insert Symbol feature as Word. KKilpatrick Excel Discussion (Misc queries) 3 April 14th 05 12:54 AM
How to insert carriage return in the middle of a text formula to . Dave Excel Discussion (Misc queries) 2 March 17th 05 02:14 PM
Suddenly can't insert text box, Why? Fairmont Excel Discussion (Misc queries) 1 March 15th 05 07:54 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM


All times are GMT +1. The time now is 02:48 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"