241.000.32ELECTRIC BBQ SL-3050
Suppose this on cell a one , what is formula on b1 to
have space after 241.000.32
241.000.32ELECTRIC BBQ SL-3050
Suppose this on cell a one , what is formula on b1 to
have space after 241.000.32
If the format will always be the same, then try this...
=left(A1,10)&"-"&mid(A1,11,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes sure , I had joined because of some pivot table analysis
Thanks for a speedy answer
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks