LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Insert a special character in 1st and last position into a cell

Hello, this may be kiddstuff to yuo but a huge problem to me and I'm sure
I need to insert the * character ex.
the value in cell A1 is 1
I want to change it to *1*
I want to change the hole column to the *#* format.
I have tryed userdefined formatting but without any luck...
Thank you in advance..
--
Mugge
The dane
 
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
Return True if cell contains special character linglc Excel Discussion (Misc queries) 4 April 5th 23 02:46 PM
how to insert a special character (arrow) in IF statement HA@Work Excel Worksheet Functions 4 April 4th 23 11:33 AM
Can I create a special character for the Character Map? JohnP Excel Discussion (Misc queries) 3 December 24th 06 01:10 AM
inserting special character in a cell as a macro johnnyboy New Users to Excel 3 September 11th 06 09:05 PM
Insert a special character before and after a word Venkatesh V Excel Discussion (Misc queries) 1 February 21st 05 02:07 PM


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