Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Add a character to the middle of a text string

I need to insert a full stop between the fourth and fifth character of a six
character string.

How do I do it?

Thank you.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Add a character to the middle of a text string

Here are the steps to add a full stop between the fourth and fifth character of a six-character string in Microsoft Excel:
  1. Select the cell that contains the text string you want to modify.
  2. Click on the formula bar at the top of the screen to activate it.
  3. Use the formula
    Code:
    =LEFT(A1,4)&"."&RIGHT(A1,2)
    to insert a full stop between the fourth and fifth character of the text string. (Note: Replace "A1" with the cell reference of the cell containing the text string you want to modify.)
  4. Press Enter to apply the formula to the cell.
  5. The modified text string with the full stop in the middle should now appear in the cell.

That's it! You have successfully added a full stop between the fourth and fifth character of a six-character string in Microsoft Excel.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Add a character to the middle of a text string

Hi Glynn

Try
=LEFT(A1,4)&"."&RIGHT(A1,2)

--
Regards

Roger Govier


"Glynn Taylor" wrote in message
...
I need to insert a full stop between the fourth and fifth character of
a six
character string.

How do I do it?

Thank you.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Add a character to the middle of a text string

Thank you Roger that's perfect.

Regards

Glynn

"Roger Govier" wrote:

Hi Glynn

Try
=LEFT(A1,4)&"."&RIGHT(A1,2)

--
Regards

Roger Govier


"Glynn Taylor" wrote in message
...
I need to insert a full stop between the fourth and fifth character of
a six
character string.

How do I do it?

Thank you.




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
Problem with VB string character limit. AJL Excel Worksheet Functions 0 November 3rd 06 08:40 PM
edit text string in column B useR Excel Discussion (Misc queries) 7 April 7th 06 10:10 PM
Find last occurance of character in text string JDay01 Excel Worksheet Functions 2 February 14th 06 05:29 PM
How do I look up a number within a string of text Rich Hayes Excel Worksheet Functions 3 October 14th 05 05:49 PM
Remove text leading zero in text string Peo Sjoblom Excel Worksheet Functions 0 May 27th 05 09:59 PM


All times are GMT +1. The time now is 11:45 AM.

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

About Us

"It's about Microsoft Excel"