Hi,
I'd like to create a custom cell format. I have strings of various lengths in individual cells and I want to show them with a space in-between every third letter. The strings can be anywhere from 12 to 26 characters in length.
One example:
Original: CTTCTGACACCGCTGGTCTG
After custom formatting: CTT CTG ACA CCG CTG GTC TG
Any suggestions would be greatly appreciated!
Thanks
Last edited by Einstahb; 09-01-2011 at 03:48 PM.
You can't do that with cell formatting.
One way is to use a formula in another cell, e.g. with data in A1 use this formula in B1
=TRIM(MID(A1,1,3)&" "&MID(A1,4,3)&" "&MID(A1,7,3)&" "&MID(A1,10,3)&" "&MID(A1,13,3)&" "&MID(A1,16,3)&" "&MID(A1,19,3)&" "&MID(A1,22,3)&" "&MID(A1,25,3))
Audere est facere
That worked well!
It would still be nice if a format could be added to avoid the need of an additional column. But if it's not possible, there's not much else I can do, I suppose.
Thanks for the quick reply!
Once you have the results, you can copy that column back over your original using Paste Special> Values and then clear the second column.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks