Hi,
Is that possible?
I have addresses in Excel cells, and need to insert a comma every 50 characters (max of 2 commas if possible).
eg.
[FONT="]ISTS Building E Mawson Lane 349 Gibson Road Maybury 9061
[/FONT][FONT="]becomes
ISTS Building E Mawson Lane 349 Gibson Road Maybur,y 9061[/FONT]
I found some help on another board that suggested something like this for a similar issue, but I have no idea how to change that to suit me!
=LEFT(F4,50)&","&MID(F4,1,50)
which just keeps repeating the same 50 characters and deleting the rest.
Thanks,
Narelle
Is that possible?
I have addresses in Excel cells, and need to insert a comma every 50 characters (max of 2 commas if possible).
eg.
[FONT="]ISTS Building E Mawson Lane 349 Gibson Road Maybury 9061
[/FONT][FONT="]becomes
ISTS Building E Mawson Lane 349 Gibson Road Maybur,y 9061[/FONT]
I found some help on another board that suggested something like this for a similar issue, but I have no idea how to change that to suit me!
=LEFT(F4,50)&","&MID(F4,1,50)
which just keeps repeating the same 50 characters and deleting the rest.
Thanks,
Narelle