Adding full stops (dots) into existing cell information ?

Hi and welcome to the board
try =left(a1,3)&"."&mid(a1,4,4)&"."&mid(a1,8,2)&"."&right(a1,2)

Many thanks and Hello

That worked a treat.

You're welcome. And thx for adding " solved" to your title !

I think I may have added the Solved too early

Half way down the sheet I found a random selection of cells with 3 digits at the end instead of 2.

I figured out to change the last 2 to a 3 which shows the extra digit, but wondered if I can now create an 'IF' rule that uses one or the other formula depending on the number of characters in the original cell ?

You can base your formula on the LEN function.
Maybe post a small sample?

Sorry, but I am not quite sure where to start with the sample as I don't know exactly how to write the formula.

What I am thinking in my head is trying to create a forumla that effectively says...

'If A1 is 11 characters then do action 1 (the original formula above), but if A1 is 12 characters then do action 2 (the modified formula)'

I get the LEN option and think this is the key to the IF formula, but I can't work out what to do with it.

You can post a sample of your data.
On the Quick Reply form click " go advanced" then scroll down to " manage attachments"
You then can add an xls sample file
To solve your problem, you don't need an if, but what is important to know is which format you need at the end.
You example is xxx.xxxx.xx.xx But if it is 12 characters long what should the format be?

oops, I wasn't quite sure of exactly what you meant by sample.

Here it is, with the two options I am tryingto convert.

This should do

Cool, that one does exactly what is needed.

Many thanks once more