[Solved] Format cell spacing

[tac45]

[ 231247 berocca ]
is a cells content entered automatically
(the [ ] is supposed to represent a cells border it is not part of the content)

I actually want
[ 231247 berocca ]
I do not want to use two cells as the information is in fact copied from a csv file exported from another program.

I just wondered if the cell could be formatted to automatically once put x number of spaces between numbers and letters

[ 231247 _ _ _ _ _ _ berocca ] for example but without the underlines being visible.

cheers for any help received.

 

[Maruf Hasan]

Hello tac45,

Welcome to our ExcelDemy Forum! Based on your post, I understand you wish to put 'x' blank spaces between your numbers and texts. You can easily do that using some functions in Excel. Please apply the mentioned formula to do that.

 =LEFT(A1,6)&REPT(" ", 6)&RIGHT(A1,LEN(A1)-6)

Here in this formula, we used four functions.
The LEFT function selects the leftmost characters in a string. Here, we selected six characters as there are six digits in the string. Then, the REPT function repeats any input you give. So we put space and told it to repeat six times. Next, we used the RIGHT function to call the rightmost characters of the string. We get that by subtracting the first six characters from the total length of the string using the LEN function.

Hope this helps you to get your desired result.

Regards,
Maruf Hasan

 

[tac45]

Thank you very much , that is great.

 

[shamimarita]

Thank you very much , that is great.

Hi tac45,

You are most welcome.