A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to put space in between each Character in same cell with formula



 
 
Thread Tools Display Modes
  #1  
Old December 8th 16, 11:16 AM posted to microsoft.public.excel.worksheet.functions
Sunil V
external usenet poster
 
Posts: 3
Default How to put space in between each Character in same cell with formula

Hi,

How to put space in between each Character in same cell with formula
For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to add Space in between each character in A1 Cell with formula


Regards
Sunil.V

Ads
  #2  
Old December 8th 16, 11:44 AM posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
 
Posts: 3,451
Default How to put space in between each Character in same cell with formula

Hi,

Am Thu, 8 Dec 2016 03:16:12 -0800 (PST) schrieb Sunil V:

> How to put space in between each Character in same cell with formula
> For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to add Space in between each character in A1 Cell with formula


try it with a macro.
For each cell in column A:

Sub Space()
Dim i As Long, LRow As Long
Dim rngC As Range
Dim myStr As String

With ActiveSheet
LRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For Each rngC In .Range("A1:A" & LRow)
myStr = rngC.Text
For i = 2 To Len(myStr) * 2 - 1 Step 2
myStr = Left(myStr, i - 1) & " " & Mid(myStr, i)
Next
rngC = myStr
Next
End With
End Sub


Regards
Claus B.
--
Windows10
Office 2016
  #3  
Old December 8th 16, 01:47 PM posted to microsoft.public.excel.worksheet.functions
Sunil V
external usenet poster
 
Posts: 3
Default How to put space in between each Character in same cell with formula

On Thursday, December 8, 2016 at 4:46:15 PM UTC+5:30, Sunil V wrote:
> Hi,
>
> How to put space in between each Character in same cell with formula
> For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to add Space in between each character in A1 Cell with formula
>
>
> Regards
> Sunil.V


Thanks for your support....
Can you suggest me any basic formula for this ???
  #4  
Old December 8th 16, 03:10 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
 
Posts: 3,451
Default How to put space in between each Character in same cell with formula

Hi,

Am Thu, 8 Dec 2016 05:47:45 -0800 (PST) schrieb Sunil V:

> Can you suggest me any basic formula for this ???


a formula is very long and not really readable:
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,2,1," "&MID(A1,2,1)),4,1," "&MID(A1,3,1)),6,1," "&MID(A1,4,1)),8,1," "&MID(A1,5,1)),10,1," "&MID(A1,6,1))


Regards
Claus B.
--
Windows10
Office 2016
  #5  
Old December 8th 16, 05:28 PM
tamnhu099341 tamnhu099341 is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 1
Default

omachi
mì omachi
mì gói omachi
  #6  
Old December 9th 16, 10:10 AM
PhunuSEO PhunuSEO is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 9
Default

Đầu tiên Khô g* Trang Moon xin phép các mod cho mình quảng cáo một b*i ở diễn đ*n nhé.

Từ lâu nay, các món khô Bò, khô Nai l*m mình l*m mẩy trên thị trường về độ dễ ăn của nó, tuy nhiên hai loại khô n*y có nhược điểm l* ăn cùng vị v* cứng. Ng*y nay, với công nghệ cải tiến, ướp vị v* đánh xé g* th*nh từng thớ nhỏ được phát minh, chúng tôi xin giới thiệu đến các bạn món khô g* xé cay cực ngon. Món n*y hợp với hầu hết các bạn cả nam v* nữ, từ mọi ngh*nh nghề, lao động hay văn phòng đều có thể nhâm nhi được hết nhé. Vì lý do diễn đ*n không cho post ảnh nhiều, mình đưa lên một ảnh đại diện cho các bạn chiêm ngưỡng nhé. Các thông tin cụ thể các bạn có thể theo thông tin bên dưới để tham khảo.

https://scontent-sin6-1.xx.fbcdn.net...c1&oe=58BF2A43

Ngo*i ra, các bạn muốn kinh doanh thì có thể liên hệ Inbox facebook page hoặc Zalo đều được nhé

Trang chủ :khogatrangmoon.com (Các bạn copy dán lên trình duyệt nhé)

Facebook : facebook.com/khogatrangmoon (Các bạn copy dán lên trình duyệt nhé)

Điện thoại - Zalo (gọi nhắn tin đều được nhé) : 0938.666.712 - 0938.666.713


GIÁ TRÊN CÁC TRANG CÓ THỂ THAY ĐỔI THEO THỜI GIÁ, CÁC B*N LIÊN HỆ SẼ ĐƯỢC BÁO GIÁ CHÍNH XÁC NHÉ
  #7  
Old December 9th 16, 11:11 AM posted to microsoft.public.excel.worksheet.functions
Sunil V
external usenet poster
 
Posts: 3
Default How to put space in between each Character in same cell with formula

On Thursday, December 8, 2016 at 4:46:15 PM UTC+5:30, Sunil V wrote:
> Hi,
>
> How to put space in between each Character in same cell with formula
> For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to add Space in between each character in A1 Cell with formula
>
>
> Regards
> Sunil.V


yes, it is too long,,,,
But it is working....
Thank you Claus Busch
  #8  
Old December 9th 16, 02:50 PM
DungSports DungSports is offline
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 5
Default

nghe được đấy cái n*y có giao h*ng t*n nơi không nhỉ để em l*m một cái
_________________
duramine

https://t.co/ecfjfzozd4
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
is 3rd character in a cell a space? Rick[_10_] Excel Worksheet Functions 5 December 21st 09 07:22 PM
Can i give Space/some other character in between the cell? sumit Excel Worksheet Functions 5 December 9th 08 07:34 AM
How do I replace a BEL Character of 7 with a space KBear Excel Discussion (Misc queries) 1 June 6th 06 03:56 PM
NEED HELP-----Removing a space at the end of a string of character FRS Excel Discussion (Misc queries) 7 April 13th 06 03:57 AM
Detecting the space character JN[_5_] Excel Programming 4 January 17th 06 05:11 PM


All times are GMT +1. The time now is 12:17 AM.


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