View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
 
Posts: 169
Default Adding alpha-numeric value in from all alphabetic content in a

You'll have to write this formula Jarek gave you in a new column and then
copy the formula down the length of your data set.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"capxc" wrote:

Do I put this command in format cell?
How to copy down?
Sorry , I am not very techie.
Please give me some lights.
Sincerely,
--
capxc


"Jarek Kujawa" wrote:

="08FG55"&D1

then copy down