Formating text

  • Thread starter Thread starter Amjad
  • Start date Start date
A

Amjad

I have a column full of single-word names. I want to
insert a dot (.) after every two consecutive letters. For
example if the name is: Amjad, then it will become:
Am.ja.d

Is there a quick way of doing that? like selecting the
whole column then format its contents in the manner
described above?

Thanks
Amjad
 
Hi Amjad
How about tha formula like this, assuming the single-word name is in the cell A1:

=Left(A1,2)&"."&Mid(A1,3,2)&"."&Right(A1,Len(A1)-Left(A1,4))

Take the left 2 characters of A1 and add a dot and add the middle of A1 starting from the 3rd character grab 2 characters that being the 3rd and 4th characters and add a dot and then coming in from the right of A1 grab the full length of the name minus the left 4 characters.

Hope this makes sense Cathi :)
 
Thanks Cathi, but unfortunately this doesn't work.
Besides the fact the formula you provided results
in "#VALUE!", you assumed that names will have similar
length, which is not the case.

Also I wanted to change the column values itself rather
than making another column with the changes.

It's like "Find and Replace" sort of thing.

Amjad

-----Original Message-----
Hi Amjad
How about tha formula like this, assuming the single- word name is in the cell A1:

=Left(A1,2)&"."&Mid(A1,3,2)&"."&Right(A1,Len(A1)-Left (A1,4))

Take the left 2 characters of A1 and add a dot and add
Click to expand...
the middle of A1 starting from the 3rd character grab 2
characters that being the 3rd and 4th characters and add
a dot and then coming in from the right of A1 grab the
full length of the name minus the left 4 characters.
 
Back
Top