i want re alter my numbers with special characters

[vengatvj]

i have many numbers in A column, i want all that numbers in one column with special characters.

is there any way to make like this?

[Winon]

Hello vengatvj,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Regards

[AlKey]

Try this:

="CUG "&"("&A2&" / "&A3&" / "&A4&")"

[vengatvj]

ya its slightly working. need more..

[AlKey]

You need more of what?

[Winon]

@ vengatvj and AlKey,

Please take note of the Moderation requests.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Thank you.

[AlKey]

@ vengatvj and AlKey,

Please take note of the Moderation requests.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Thank you.

Sorry Winon,

I was in the process of replying to OP before you posted your note. Otherwise I would certainly comply with your request.

[vengatvj]

SORRY ALL, I CHANGED TITLE.. , alkey pls write formula in my excel, i cant copy past. its not working..

[vengatvj]

its working only 3 numbers.. some times i need to enter many numbers numbers.. its not working more than 3 numbers...

[AlKey]

There were only three numbers in your spreadsheet. You would have to add cells based on the pattern in the formula in order to capture more numbers. Otherwise, I think you may need to look to a VBA solution for your problem.

[vengatvj]

i have a many details in my excel, many formulas in my excel so that very slow, again i don't want create another one formula.
is there any way to keep formula in any source? its not working while copy and paste from other sheet, i don't know what to do,

i tried in auto-correct options. if i type A* then it replace as my formula., this way also not working , because the base address in my formula not changing, while using this shortcut , friends pls tell me any other solutions

see my excel,

[alansidman]

I have looked at your spreadsheet. I don't understand the logic you need to capture the information in Column I and concatenate the information in column AE. In simple language, please explain the logic if you were to do this manually and not in Excel. How do you determine which records from column I should appear in column AE?

[vengatvj]

some times i need to enter 5 or 10 mobile numbers in i column, all that numbers should type in AE row all numbers should be in single cell with , or / , just i asked is there any other way? if possible tell me or leave this thread

[vengatvj]

="CUG "&"("&A2&" / "&A3&" / "&A4&" / "&A5&" / "&A6&" / "&A7&")"

if i enter only 3 mobile numbers in A column then it be shows as you gave formula, (cug number1 / number2 / number 3/ / / / /)
its not looking good if i enter 3 number only then it should be view like this ( cug number 1 / number 2 / number 3)
if i enter 5 mobile numbers, then should be close bracket after 5th number is end

[alansidman]

You have posted the same question issue in two different threads. I have combined them for the benefit of all forum members. Please do not post the same question in more than one thread. You have been a member of this forum long enough to understand our rules. Please adhere to them in the future.

[vengatvj]

ok , sorry , its very good website, i learnt many things.. i will follow all your rules..

[Winon]

Hello vengatvj,

To cater for 12 or less Numbers your formula will look like this:

=IF(A13<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" / " &A12&" / " &A13&" ) ",IF(A12<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" / " &A12&" ) ",IF(A11<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" ) ",IF(A10<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" ) ",IF(A9<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" ) ",IF(A8<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" ) ",IF(A7<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" ) ",IF(A6<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" ) ",IF(A5<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" ) ",IF(A4<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" ) ",IF(A3<>"","CUG"&" ( "&A2&" / "&A3&" ) ",IF(A2="","",IF(A2<>"","CUG"&" ( "&A2&" )"," ")))))))))))))

Just make sure that you don't leave empty Rows or Cells, between the numbers.

Also see the attached sample Workbook.

Regards

[vengatvj]

thanks a lot winon,, its working very well. i edit this formula for more than 30 numbers, thank you so much dear friend...

[Winon]

Hello vengatvj,

You are welcome.

Glad I could help.

You may also Click on the Star to the far left, at the bottom of this Post, to Add Reputation.

Regards

[Winon]

Hello vengatvj,

Thank you for having marked your Thread as Solved, and for adding to my Reputation.

[vengatvj]

winon my another one thread is there. No one reply me yet..