Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 5th 06, 09:57 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 23
Default Insert letter/no among word

Hi, can anybody tell me how to insert letter/no among a word/no. e.g. America
i want to put 1 that become Ame1rica in the middle. Thanks friend

  #2   Report Post  
Old October 5th 06, 10:19 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,594
Default Insert letter/no among word

=left(A1,3)&1&right(A1,len(a1)-3)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ShamsulZ" wrote in message
...
Hi, can anybody tell me how to insert letter/no among a word/no. e.g.

America
i want to put 1 that become Ame1rica in the middle. Thanks friend



  #3   Report Post  
Old October 5th 06, 10:39 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 247
Default Insert letter/no among word

the replace or substitute function wil let you replace say r in america with
r1.
=REPLACE(G3,FIND("e",G3,1),1,"e1")."america" is in cell G3 and the formula
returns
ame1rica.
--
paul

remove nospam for email addy!


ame1rica
"ShamsulZ" wrote:

Hi, can anybody tell me how to insert letter/no among a word/no. e.g. America
i want to put 1 that become Ame1rica in the middle. Thanks friend



Reply
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
Create a Word Table from a Excel Macro Silvia Excel Discussion (Misc queries) 0 September 7th 06 12:34 AM
Translation Exercise ... Rebecca Excel Worksheet Functions 9 June 6th 06 09:18 PM
Insert Excel hyperlink to word document BHalberstater Excel Worksheet Functions 0 April 26th 06 08:54 AM
How can I insert same word into selected column ZigZig Excel Discussion (Misc queries) 1 February 6th 06 09:40 AM
Excel should have the same Insert Symbol feature as Word. KKilpatrick Excel Discussion (Misc queries) 3 April 14th 05 12:54 AM


All times are GMT +1. The time now is 05:27 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017