[Solved] Format cell spacing

tac45

New member
[ 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.
 
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.

Code:
 =LEFT(A1,6)&REPT(" ", 6)&RIGHT(A1,LEN(A1)-6)
1684058950689.png

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
 

Online statistics

Members online
0
Guests online
12
Total visitors
12

Forum statistics

Threads
318
Messages
1,408
Members
583
Latest member
mibr fan token
Top