Formating text

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
 
C

Cathi Payne

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 :)
 
A

Amjad

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.
 
Top